SQL Verify was created with the aim of providing you, a SQL Server DBA, the means to verify your SQL Server backups easily and reliably.
The basic idea is that you cannot rely on RESTORE VERIFYONLY to validate your backup files (we explain why here). You need to restore the backup sets to really gain the confidence that your backup sets are recoverable.
Once you've done that at least once, there is a better way to validate the backup files when you copy them to other locations for storage, or when you just want to periodically ensure that the backup sets you have on disk are still recoverable. You can read more about that here.
Now setting up a system to do the above isn't easy, and that's where SQL Verify comes in. Get SQL Verify and try it to see what it's all about!
What's New in This Release: [ read full changelog ]
· Unicode support added to all job settings.
· Fixed bug with CHECKDB job - undo file name was always reverting to the default value.
· Fixed some GUI inconsistencies.