代码实现ASP.NET数据库的备份和还原
//数据库备份 protected void btnBackup_Click(object sender, EventArgs e) { string bakname = "cc"; string sql = "backup database tt to disk = '" + Server.MapPath("").ToString() + "\\" + bakname //备份文件名 + ".bak'"; SqlConnection scon = new SqlConnection("server=.;u); scon.Open(); SqlCommand sc = new SqlCommand(sql, scon); sc.ExecuteNonQuery(); } //数据库的还原 protected void Button1_Click(object sender, EventArgs e) { //string path = this.FileUpload1.PostedFile.FileName; //获得备份路径及数据库名称 string path = "D:/1.BAK"; //string dbname = this.DropDownList1.SelectedValue; string SqlStr1 = "Server=.;database=WebZone;U; string SqlStr2 = "use master restore database WebZone from disk='" + path + "'"; SqlConnection con = new SqlConnection(SqlStr1); con.Open(); try { SqlCommand com = new SqlCommand(SqlStr2, con); com.ExecuteNonQuery(); Response.Write("<script language=javascript>alert('还原数据成功!');</script>"); } catch (Exception error) { Response.Write(error.Message);Response.Write("<script language=javascript>alert('还原数据失败!');</script>"); } finally { con.Close(); } } |