1. 备份：use master;backup database @name to disk=@path;
   恢复：use master;restore database @name from disk=@path;
5. string dbFileName = txtDbFileName.Text.Trim();
6.          SqlConnection connection = new SqlConnection("Data Source=ZHOUFOXCN;User ID=sa;Password=sa");
7.         string dbName = ddlDatabaseList.SelectedValue;
8.         if (!dbFileName.EndsWith(".bak"))
9.          {
10.              dbFileName += ".bak";
11.          }
12.         if (rbBackup.Checked)//备份数据库
13.          {
14.              SqlCommand command = new SqlCommand("use master;backup database @name to disk=@path;",connection);
15.              connection.Open();
16.             string path=Server.MapPath("~\\App_Data")+"\\"+dbFileName;
17.              command.Parameters.AddWithValue("@name", dbName);
18.              command.Parameters.AddWithValue("@path", path);
19.              command.ExecuteNonQuery();
20.              connection.Close();
21.          }
22.         else//恢复数据库
23.          {
24.              SqlCommand command = new SqlCommand("use master;restore database @name from disk=@path;", connection);
25.              connection.Open();
26.             string path = Server.MapPath("~\\App_Data") + "\\" + dbFileName;
27.              command.Parameters.AddWithValue("@name", dbName);
28.              command.Parameters.AddWithValue("@path", path);
29.              command.ExecuteNonQuery();
30.              connection.Close();
31.          }

• 本文标题： 网站后台数据库备份和恢复
• 文章分类：【.NET/Web】
• 非特殊说明，本文版权归【胡同里的砖头】个人博客 所有，转载请注明出处.

• 上一篇：用户sa登陆失败，原因“未与信任的SQL se
• 下一篇： SQL 修改数据库名称