备份与还原SQL Server 数据库

1、C# 备份数据库

Str_dar = System.Environment.CurrentDirectory + "\\bar\\";
Str_dar = "backup database db_PWMS to disk='" + Str_dar + (System.DateTime.Now.ToShortDateString()).ToString() + MyMC.Time_Format(System.DateTime.Now.ToString()) + ".bak" + "'";
DAL.SQLHelper.ExecuteNonQuery(Sql, CommandType.Text, null);
Response.Write("数据库备份成功！");

 

 

3、ASP 还原数据库

 String Sql="";
 string Str_dar = Server.MapPath("~//App_Data") + "\\";
 Sql = "backup database construction to disk='" + Str_dar + (System.DateTime.Now.ToShortDateString()).ToString() + Time_Format(System.DateTime.Now.ToString()) + ".bak" + "'";
 DAL.SQLHelper.ExecuteNonQuery(Sql, CommandType.Text, null);
 Response.Write("数据库备份成功！");