数据库的备份和还原代码

备份：代码如下

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();

  }

还原数据库代码如下：

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();

  }

若要实现自动还原和备份数据库，只需写个定时器定时调用方法即可！