SQLDMO.Backup and ProgressBar

Hi all
My requirement is to "on button_click, backup a SQL
database using SQLDMO.Backup object and update the
progress in a ProgressBar. The problem is the progress
bar does not update at all until the very end of the
backup process, when the backup is almost going to be
over, the progress bar updates itself once on a stretch,
which is no use,it is not showing any progress.

SQLDMO documentation says, the SQLDMO.Backup object fires
PercentComplete event every 10% of the process. I
appreciate all your help in figuring this out. Thanks a
lot.

private void button1_Click(o bject sender,
System.EventArg s e)
{
string DatabaseName = "MySqlServerDB" ;
string BackupFileName = PathFileName.Te xt;
string Prefix = " button1_Click: ";

//check if the text box contains a valid backup
name and path
if(!PathFileNam e.Text.EndsWith (".bak"))
{
MessageBox.Show ("Enter a valid Backup
path and file name. ");
goto ExitClick;
}

string BackupDir = Path.GetDirecto ryName
(BackupFileName );
if(!Directory.E xists(BackupDir ))
{
MessageBox.Show ("Invalid Path
specified. ");
goto ExitClick;
}
if(!JobHelperOb j.CheckDiskSpac e(BackupDir))
{
MessageBox.Show ("Insufficie nt disk space
in the drive. Backup will not continue. ");
goto ExitClick;
}

this.Cursor = Cursors.WaitCur sor;
progressBar1.Vi sible = true;

try
{
//declare an instance of SQLDMO.Backup
SQLDMO.Backup DMOBackup = new
SQLDMO.BackupCl ass();
SQLDMO.SQLServe r SqlServerObj = new
SQLDMO.SQLServe rClass();
SqlServerObj.Na me = ".";
SqlServerObj.Lo ginSecure = true;
SqlServerObj.Co nnect(".",null, null);

DMOBackup.Datab ase = DatabaseName;
DMOBackup.Files = BackupFileName;

// Delete the datafile to allow the
application to create a brand new file.
// This will prevent attaching the new
backup data to the old data if there
// is any.
if(File.Exists( BackupFileName) )
File.Delete(Bac kupFileName);

DMOBackup.Perce ntComplete += new

SQLDMO.BackupSi nk_PercentCompl eteEventHandler
(this.SqlBackup PercentComplete );

DMOBackup.SQLBa ckup(SqlServerO bj);
MessageBox.Show ("Backup complete");

this.Cursor = Cursors.Default ;
progressBar1.Vi sible = false;
progressBar1.Va lue = 0;

DMOBackup = null;
}
catch(Exception excep)
{
TraceMessage = " ERROR: " + Prefix +
excep.Message + ". " + e.GetType().ToS tring() + ". " +
" Exception occurred. ";
ErrorMessage = " ERROR: Unable to get the
BackupPath from DAHS table. ";
Log(TraceMessag e);
Log(ErrorMessag e, true);
MessageBox.Show (excep.Message + " Backup failed.
One of the possible causes could be Insufficient disk
space. ");
}
ExitClick:;
}

private void SqlBackupPercen tComplete(strin g message, int
Percent)
{
progressBar1.Va lue = Percent;
progressBar1.Up date();
}

[The Last Gunslinger]

an*******@discu ssions.microsof t.com wrote:

Hi all
My requirement is to "on button_click, backup a SQL
database using SQLDMO.Backup object and update the
progress in a ProgressBar. The problem is the progress
bar does not update at all until the very end of the
backup process, when the backup is almost going to be
over, the progress bar updates itself once on a stretch,
which is no use,it is not showing any progress.

Have you tried debugging it to see how many times the event fires?
Try writing to the debug stream (debug.WriteLin e("Text")) in the
eventhandler and see what happens.

Post back with results if required.

HTH
JB