Restore database:
Keywords: Alter database recovered database name set offline with rollback immediate;
From disk = 'backup file path ';
Alter database recovered database name set online with rollback immediate;
/////////////////////
String SQL = "alter database dB set offline with rollback immediate ;"; // DB is the name of the database to be backed up
SQL + = "Restore database DB from disk = '";
SQL + = server. mappath (""). tostring () + "\\";
SQL + = bakname + "'";// Bakname is the backup file name
SQL + = "alter database dB set online with rollback immediate ;";
Try
{
Connection Master Database;
Run SQL Statement;
Response. Write ("<script language = JavaScript> alert ('data recovery successful! '); </SCRIPT> ");
}
Catch (exception ex)
{
Response. Write ("<script language = JavaScript> alert ('data recovery failed! '); </SCRIPT> ");
This. label2.text = ex. tostring ();
}
Back up the database:
Keyword: backup database backed up database name to disk = 'backup file path ';
//
string SQL = "backup database dB disk = '"+ server. mappath (""). tostring () + "\"
+ bakname // backup file name
+ system. datetime. now. dayofyear. tostring ()
+ system. datetime. now. millisecond. tostring () + ". bak '";
database data = new database ();
data. oper_data (SQL);
response. Write (" ");