November 18, 2002 at 12:37 pm
Does anyone know how to determine the progress of backups?
I have set up a scheduled job in SQL 7.0 to use the BACKUP command.
I have the job email me when it finishes, but sometimes I would like to know how close it is to getting done.
Steven R. Morrow
Steven R. Morrow
November 18, 2002 at 1:18 pm
you can check the Backup file size to see How much is backed up.
November 18, 2002 at 1:28 pm
If you let the backup log to file, the file logs every next 10% of the backup made.
November 18, 2002 at 3:52 pm
If you use DMO you can get an event to fire that matches the withstats value so you can update a progress bar or whatever.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply