1
Reply

How To Restore .bak File in sql Database Using c#???

Mukesh Kumar Tiwari

Mukesh Kumar Tiwari

10 years ago
4.2k
hi friends...
 
                     i have a .bak file of sql server database. and now i want to restore that database in the sqlserver database using c#.net.
 
                     i am using the below query
                   string query = "RESTORE DATABASE'"+cmd_database_list.Text.Trim()+"' FROM DISK = '" + txt_back_file.Text.Trim() + "'"; 
 
                     an error occured that 
                  Cannot open backup device 'E:\Print_Label13-08-2014.bak'. Operating system error 2(The system cannot find the file specified.).    
                     RESTORE DATABASE is terminating abnormally.
 
                i am not geting that what to do now????
                Please help me out...
Thanks... 
 

Answers (1)
Next Recommended Forum