技术开发 频道

ASP.NET备份恢复Sql Server数据库


【IT168技术文档】

  本文将向大家介绍如何使用 ASP.net 备份恢复 SQL Server 数据库,大家可以做个参考,也希望对大家有所帮助。

  备份SqlServer数据库:
string SqlStr1 = "Server=(local);database='" + this.DropDownList1.SelectedValue + "';Uid=sa;Pwd=";   string SqlStr2 = "backup database " + this.DropDownList1.SelectedValue + " to disk='" + this.TextBox1.Text.Trim() + ".bak'";   SqlConnection con = new SqlConnection(SqlStr1);   con.Open();   try   {   if (File.Exists(this.TextBox1.Text.Trim()))   {   Response.Write(" ");   return;   }   SqlCommand com = new SqlCommand(SqlStr2, con);   com.ExecuteNonQuery();   Response.Write(" ");   }   catch (Exception error)   {   Response.Write(error.Message);   Response.Write(" ");   }   finally   {   con.Close();   }
  还原SqlServer数据库:
string path = this.FileUpload1.PostedFile.FileName; //获得备份路径及数据库名称   string dbname = this.DropDownList1.SelectedValue;   string SqlStr1 = "Server=(local);database='" + this.DropDownList1.SelectedValue + "';Uid=sa;Pwd=";   string SqlStr2 = "use master restore database " + dbname + " from disk='" + path + "'";   SqlConnection con = new SqlConnection(SqlStr1);   con.Open();   try   {   SqlCommand com = new SqlCommand(SqlStr2, con);   com.ExecuteNonQuery();   Response.Write(" ");   }   catch (Exception error)   {   Response.Write(error.Message);   Response.Write(" ");   }   finally   {   con.Close();   }
0
相关文章