How can we help you today? How can we help you today?

Backup showing as In Progress after job has finished

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 ?
cameron.gibbs
0

Comments

4 comments

Sort by
  • ChrisAVWood
    Are you using the 5.3 version? Do you have the VERIFY option on your backup? If so this is a known problem. Maybe fixed in 5.4.

    Chris
    ChrisAVWood
    0
  • cameron.gibbs
    um 5.3 is the latest version...I downloaded it yesterday
    cameron.gibbs
    0
  • Matthew Flatt
    Hi Cameron,

    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
    Matthew Flatt
    0
  • cameron.gibbs
    Thanks Matthew - I did find closing/opening the GUI worked.
    cameron.gibbs
    0

Add comment

Please sign in to leave a comment.