备份还原文件的方法

 protected void bfsjk_Click(object sender, EventArgs e)         {             string nowTime = DateTime.Now.ToString("yyyy-M-dd H:m:s");             string newname = DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒") + ".bak";             string ConString = System.Configuration.ConfigurationManager.AppSettings["SourceDataLink"].ToString();             SqlConnection conn = new SqlConnection(ConString);             conn.Open();             //SqlCommand cmd = new SqlCommand("backup database [B1232] to disk='E:/wwwroot/B1230/" + newname + "'", conn);             SqlCommand cmd = new SqlCommand("backup database [B1232] to disk='" + Server.MapPath("~/" + newname) + "'", conn);             string sqlinsert = "insert into adminDatabase (dataName,dataTime)values('" + newname + "','" + nowTime + "')";             SqlCommand cmdinser = new SqlCommand(sqlinsert, conn);             //string sqlinsert = "insert into adminDatabase (dataName,dataTime)values('" + newname + "'," + nowTime + ") ";             cmdinser.ExecuteNonQuery();             cmd.ExecuteNonQuery();             cmd.Dispose();             conn.Close();             MessageBox("备份成功！");         }         protected void Button2_Click(object sender, EventArgs e)         {             // + this.FileUpload1.PostedFile.FileName             string path = "~/"; //获得备份路径及数据库名称             string dbname = this.DropDownList1.SelectedItem.Text.ToString();             string ConString = System.Configuration.ConfigurationManager.AppSettings["SourceDataLink"].ToString();             SqlConnection conn = new SqlConnection(ConString);             conn.Open();             //string SqlStr2 = "use master restore database B1232 from disk='E:/wwwroot/B1230/" + dbname + "' with replace use [B1232]";             string SqlStr2 = "use master restore database B1232 from disk='" + Server.MapPath(path) + dbname + "' with replace use [B1232]";             //"use master  Restore database [xcsrj] from disk='"&NewPath&"' with replace use [xcsrj]"B1219             try             {                 SqlCommand cmd = new SqlCommand("master.dbo.killspid", conn);                 cmd.CommandType = CommandType.StoredProcedure;                 SqlParameter spr = new SqlParameter("@dbname", SqlDbType.VarChar, 20);                 spr.Value="B1232";                 cmd.Parameters.Add(spr);                 cmd.ExecuteNonQuery();                 SqlCommand com = new SqlCommand(SqlStr2, conn);                 com.ExecuteNonQuery();                 MessageBox("还原" + dbname + "备份成功！");             }             catch (Exception error)             {                 Response.Write(error.Message);                 Response.Write("<script language=javascript>alert('还原数据失败！')</script>");             }             finally             {                 conn.Close();             }