备份数据库
- Form层
if (!MessageHelper.ConfirmYesNo("确定要备份数据库文件吗？"))
return;
string bakFile = string.Format("D:/BackUP/{0}.{1}.bak", ConfigurationManager.AppSettings["DbName"], DateTime.Now.ToString("yyyyMMdd"));
ExecutionResult res = backUpController.BackUpDB(ConfigurationManager.AppSettings["DbName"],bakFile);
if (res.Status)
{
MessageHelper.ShowTips("数据库备份成功，请在数据库服务器上查看文件" + bakFile);
}
else
{
MessageHelper.ShowError("数据库备份失败，" + res.Message);
}
- Dao层
public ExecutionResult BackUpDB(string dbName, string bakFile)
{
string cmd = string.Format("USE MASTER; BACKUP DATABASE \"{0}\" TO DISK = '{1}'", dbName, bakFile);
DBParameter dbParams = new DBParameter();
ExecutionResult exeResult = sqlHelper.ExecuteUpdate(cmd, dbParams.GetParameters());
return exeResult;
}
注：
form层中备份的文件夹D:/Backup自己定义，如果按此定义，在使用备份功能前需要首先在D盘手动新建 Backup 文件夹，否则会提示找不到路径，因此也可以在路径中取掉Backup，直接在D盘根目录创建，就不会存在此问题
还原数据库
- Form层
if (string.IsNullOrWhiteSpace(txtFile.Text.Trim()))
{
MessageHelper.ShowError("请输入或选择要还原的数据库文件路径");
return;
}
string file = txtFile.Text.Trim();
ExecutionResult res = backUpController.RestoreDB(ConfigurationManager.AppSettings["DbName"],file);
if (res.Status)
{
MessageHelper.ShowTips("数据库还原成功！");
}
else
{
MessageHelper.ShowError("数据库还原失败，" + res.Message);
}
- Dao层
public ExecutionResult RestoreDB(string dbName, string bakFile)
{
StringBuilder cmd = new StringBuilder();
cmd.Append(string.Format(" USE MASTER; ALTER DATABASE [{0}] SET OFFLINE WITH ROLLBACK IMMEDIATE; ", dbName));
cmd.Append(string.Format(" USE MASTER; RESTORE DATABASE \"{0}\" FROM DISK = '{1}' with replace;", dbName, bakFile));
cmd.Append(string.Format(" USE MASTER; ALTER DATABASE [{0}] SET ONLINE;", dbName));
DBParameter dbParams = new DBParameter();
ExecutionResult exeResult = sqlHelper.ExecuteUpdate(cmd.ToString(), dbParams.GetParameters());
return exeResult;
}
