62,046
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 数据库备份
/// </summary>
/// <param name="server">服务器地址</param>
/// <param name="ad">sql账户</param>
/// <param name="pw">sql密码</param>
/// <param name="db">要备份的数据库名称</param>
/// <param name="bkpath">备份路径</param>
/// <param name="bkname">备份文件名</param>
/// <param name="des">描述</param>
public void DbBackup(string server, string ad, string pw, string db,
string bkpath, string bkname, string des)
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect(server, ad, pw);
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = db;
oBackup.Files = @"D:\Downloads";
oBackup.BackupSetName = bkname;
oBackup.BackupSetDescription = des;
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch (Exception ex)
{
throw ex;
}
finally
{
oSQLServer.DisConnect();
}
}