Restore .bak file through C# Coding in sql server

[NarendraSinghJTV]

hii all, I have managed to create a backup file (.bak) with the help of stored procrdure found on code project examples. Now i dont know how to restore this file with the existing one for the completion of restore. can any body help me out with this problem. Can we able to rstore it from c#.

Regards Narendra Singh (Jindal Tech Ventures)

[RaviBee]

See the SMO Restore[^] class. /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

[Md Marufuzzaman]

Why you are not doing the restore process via a SQL stored procedure...?

Thanks Md. Marufuzzaman

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

[NarendraSinghJTV]

yes i m trying to do it with the help of stored procedure but i m not getting the result i m using default restore command of sql server. do u have any idea or any example to give me a start.

Regards Narendra Singh (Jindal Tech Ventures)

[Md Marufuzzaman]

The following stored procedure will restore the database. This is helpful when you need to restore the database from other applications: CREATE PROCEDURE [dbo].[sp_db_restore] @DBName varchar(60), @BackName varchar(120), @DataName varchar(60), @DataFileName varchar(120), @LogName varchar(60), @LogFileName varchar(120)    AS RESTORE DATABASE @DBName FROM    DISK = @BackName WITH MOVE @DataName TO    @DataFileName ,    MOVE @LogName TO @LogFileName, REPLACE GO Parameters    DBName - Database Name to be restored    BackName - Path & Name of the BackupFile    DataName - MDF File name    DataFileName - MDF File Path    LogName - LDF File Name    LogFileName - LDF File Path Replace: Will replace the Database if it exists.

Thanks Md. Marufuzzaman

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

[NarendraSinghJTV]

thanks for ur reply i tried ur stored procedure but it gives the following error any idea how can i remove it "RESTORE cannot process database 'databasename' because it is in use by this session. It is recommended that the master database be used when performing this operation. RESTORE DATABASE is terminating abnormally."

Regards Narendra Singh (Jindal Tech Ventures)