//还原备份 protected void btnreturn_Click(object sender, EventArgs e) { try { string str = DropDownList1.SelectedItem.Text; if (str == "") { SQLcs.AlertShow("请选择备份文件!", "managedata.aspx"); } string sql = "ALTER DATABASE " + txt_DBName.Value + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE use master restore database " + txt_DBName.Value + " from disk='" + bakpath + "\\" + str + "' with replace ALTER DATABASE " + txt_DBName.Value + " SET MULTI_USER"; if (SQLcs.DataOperater(sql)) { SQLcs.AlertShow("还原数据成功!", "managedata.aspx"); } else { SQLcs.AlertShow("还原数据失败!", "managedata.aspx"); } } catch (Exception ex) { SQLcs.AlertShow("还原数据失败!", "managedata.aspx"); Logs.WriteLog("备份数据失败!", ex.Message); mes.Alert(ex.Message, Page); } }
//备份数据 protected void Button1_Click(object sender, EventArgs e) { string bakname = TextBox1.Text.Trim(); //去掉文件名中的非法字符 bakname = bakname.Replace("\\", "").Replace("//", "").Replace("*", "").Replace(":", "").Replace("?", "").Replace("\"", "").Replace("<", "").Replace(">", "").Replace("|", ""); string sql = "backup database " + txt_DBName.Value + " to disk='" + bakpath + "\\" + bakname + ".bak'"; try { if (File.Exists(bakpath + "\\" + bakname + ".bak")) { SQLcs.AlertShow("此文件已存在,请从新输入!", "managedata.aspx"); return; } if (SQLcs.DataOperater(sql)) { SQLcs.AlertShow("备份数据成功!", "managedata.aspx"); } } catch (Exception ex) { SQLcs.AlertShow("备份数据失败!", "managedata.aspx"); Logs.WriteLog("备份数据失败!", ex.Message); } }