备份:
string Constr = “Provider=SQLOLEDB;Data Source=.;Integrated Security=SSPI;Initial Catalog=数据库名”;//.代表本机
OleDbConnection myConn = new OleDbConnection(Constr);
myConn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = myConn;
cmd.CommandText = @"backup database 要备份的数据库名 to disk = 'E:\db1.bak '";
//BACKUP DATABASE [要备份的数据库名] TO DISK = N'E:\db1.bak' WITH NOFORMAT, INIT, NAME = N'别名', SKIP, NOREWIND, NOUNLOAD, STATS = 10
cmd.ExecuteNonQuery();
myConn.Close();
恢复:
cmd.CommandText = @"restore database 要恢复的数据库名 from disk = 'E:\db1.bak' with replace";
//RESTORE DATABASE [要备份的数据库名] FROM DISK = N'E:\db1.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10