Backup showing as In Progress after job has finished
cameron.gibbs
Posts: 18
I have setup backup jobs on 3 different database servers to backup all user databases using maximum compression.
On each server there is 1 database that still shows up in the In Progress tab as being backed up, and the timeline window says Full backup.... - Finishing, even after the job has stopped running and is reported as Successful.
The database vary in size and are not the first or last databases in the backup list.
I don't know if they've been backed up properly or not !
All databases are in perfect working order.
Can anyone shed some light on this ?
On each server there is 1 database that still shows up in the In Progress tab as being backed up, and the timeline window says Full backup.... - Finishing, even after the job has stopped running and is reported as Successful.
The database vary in size and are not the first or last databases in the backup list.
I don't know if they've been backed up properly or not !
All databases are in perfect working order.
Can anyone shed some light on this ?
Comments
Chris
It looks like you are indeed bumping into a bug with the SQL Backup 5 GUI.
This generally occurs with large databases when the WITH VERIFY option is used.
Your database backup should have completed and verified successfully, you can check this by looking at the related SQL Backup log file located by default in :
%:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>
Closing and opening the GUI should return the timeline and In progress tab to normal.
Thanks
Redgate Foundry