public static void DbBackup(DelegateStep delegateStep, SqlConnection DBCon, string Filename, string Company)
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
// oSQLServer.Connect(DBCon.DababaseServer,DBCon.SuperUserID,DBCon.SuperPassword);
oSQLServer.Connect("127.0.0.1", "sa", "sql");
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = Company;
oBackup.Files = Filename;
oBackup.BackupSetName = Company;
oBackup.BackupSetDescription = "数据库备份";
oBackup.Initialize = true;
//进度条
SQLDMO.BackupSink_PercentCompleteEventHandler pceh = new SQLDMO.BackupSink_PercentCompleteEventHandler(delegateStep);
oBackup.PercentComplete += pceh; oBackup.SQLBackup(oSQLServer);
}
catch (Exception err)
{
throw (new Exception("备份数据库失败" + err.Message));
}
finally
{
oSQLServer.DisConnect();
}
}
提示: public static void DbBackup(DelegateStep delegateStep, SqlConnection DBCon, string Filename, string Company)中DelegateStep未引用空间 应该怎么改呢??
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
// oSQLServer.Connect(DBCon.DababaseServer,DBCon.SuperUserID,DBCon.SuperPassword);
oSQLServer.Connect("127.0.0.1", "sa", "sql");
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = Company;
oBackup.Files = Filename;
oBackup.BackupSetName = Company;
oBackup.BackupSetDescription = "数据库备份";
oBackup.Initialize = true;
//进度条
SQLDMO.BackupSink_PercentCompleteEventHandler pceh = new SQLDMO.BackupSink_PercentCompleteEventHandler(delegateStep);
oBackup.PercentComplete += pceh; oBackup.SQLBackup(oSQLServer);
}
catch (Exception err)
{
throw (new Exception("备份数据库失败" + err.Message));
}
finally
{
oSQLServer.DisConnect();
}
}
提示: public static void DbBackup(DelegateStep delegateStep, SqlConnection DBCon, string Filename, string Company)中DelegateStep未引用空间 应该怎么改呢??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货