RESTORE DATABASE

Minnu Merin Alex

i did back up using the following code

public static void backups()

{

string str = "use point_of_sale";

string str1 = "Backup database point_of_sale to disk='E:\\backupfile.bak'WITH FORMAT, MEDIANAME = 'SQLServerBackups', NAME = 'Full Backup of pos'";

SqlCommand cmd1 = new SqlCommand(str, Connection.Getconnection());

SqlCommand cmd2 = new SqlCommand(str1, Connection.Getconnection());

cmd1.ExecuteNonQuery(); cmd2.ExecuteNonQuery();

}

now i have a restore button .plz tell me the code i should enter

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nirav Daraniya10y ago
string str1 = "RESTORE DATABASE TestingDatabaseName FROM DISK='D:\\backupfile.bak'";
SqlCommand cmd2 = new SqlCommand(str1, Connection.Getconnection());
cmd2.ExecuteNonQuery();

OR

string str1 = @"RESTORE DATABASE TestingDatabaseName FROM DISK='D:\backupfile.bak' WITH MOVE 'MVCTest' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\DATA\MVCTestNew.MDF',MOVE 'MVCTest_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\DATA\MVCTestNew.ldf'; GO";
SqlCommand cmd2 = new SqlCommand(str1, Connection.Getconnection());
cmd2.ExecuteNonQuery();
0
Asad Ali10y ago
I guess there is a complete article explaining which is this one
http://www.c-sharpcorner.com/UploadFile/rohatash/restore-sql-server-backup-file-with-C-Sharp/
0
Minnu Merin Alex10y ago
nope..this code is working properly..what i need is the code to restore
0
Asad Ali10y ago
Hey could you be more clear. Do you mean the above code is working and do you need to call it?
0