Problem with Restore (SMO) PercentCompleteNotification

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All,

I am using SQL Server Manager Objects (SMO) Restore to restore an SQL
Database.

All works well however when I set the PercentCompleteNotification = 1
I would of expected the PercentCompleteEventHandler to trigger every one
percent, instead it triggers a total 23 times not 100.

Yet If I set PercentCompleteNotification = 10 the
PercentCompleteEventHandler will trigger ten times which is expected.

Does anyone know what the problem is?

Thanks in advance.
 
Scott said:
All,

I am using SQL Server Manager Objects (SMO) Restore to restore an SQL
Database.

All works well however when I set the PercentCompleteNotification = 1
I would of expected the PercentCompleteEventHandler to trigger every one
percent, instead it triggers a total 23 times not 100.

Yet If I set PercentCompleteNotification = 10 the
PercentCompleteEventHandler will trigger ten times which is expected.

Does anyone know what the problem is?
Click to expand...

The backup and restore percent complete messages aren't guaranteed to fire
exactly on the target percent. The PercentCompleteEventArgs has the percent
complete value, which should be accurate.

David
 
David,

Your answer was of great help.
I was able to connect this handler properly to a progress bar which now
reports the correct percentage.
Thanks.

Scott
 
Back
Top