A workaround if the GUI reports Verify incorrectly

Forum for users of Redgate's SQL Backup tool

A workaround if the GUI reports Verify incorrectly

Postby HJoyce » Wed Apr 09, 2008 4:20 pm

The VERIFY keyword is specified, a procedure is run after the backup process to check the backup file is not corrupted and can be read for restoring.

After the backup process has completed on a server an entry is recorded in the backup history.
After the verify process has completed the backup history data is updated to show the outcome of the verify process.

Unfortunately if the SQL Backup user interface is open, there's a chance that it caches the data before the verify process has finished, in which case the VERIFY column reports 'NO'.

In this case you can delete the local data cache located in the folder
C:\\Documents and Settings\\<user name>\\Local Settings\\Application Data\\Red Gate\\SQL Backup\\Server Data. This will cause the user interface to fetch the backup history data in order to create a new local cache which could have a temporary performance impact on the GUI.

This will be addressed in a future release of SQL Backup.
Posts: 149
Joined: Mon Oct 10, 2005 8:48 am

Backup Not Verifying

Postby Cscott » Wed Jun 18, 2008 3:29 pm

I am having the same problems as above but when I delete the file, and go back to the software, the colum still says NO. help please.
Posts: 2
Joined: Wed Jun 18, 2008 3:26 pm

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest