SQLDMO备份SQLServwr2005数据库不显示进度条?
private void toolBtnBF_ButtonClick(object sender, EventArgs e)
{
//备份
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
SQLDMO.BackupSink_PercentCompleteEventHandler pceh = new SQLDMO.BackupSink_PercentCompleteEventHandler(Step);
oBackup.PercentComplete += pceh;
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect(".", "sa", "sa");
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = "SCXS";
oBackup.Files = @"D:\SCXS";
oBackup.BackupSetName = "SCXS";
oBackup.BackupSetDescription = "数据库备份";
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch
{
throw;
}
finally
{
oSQLServer.DisConnect();
}
MessageBox.Show("数据库备份成功!");
}
private void Step(string message, int percent)
{
progressBar1.Value = percent;
Application.DoEvents();
}
这个备份数据库的代码在使用SQL Server 2000的时候可以显示进度条,但是在使用SQL Server2005的时候进度条就是显示不出来。请各位高手帮忙看看到底什么原因?