sqlserver backups | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sqlserver backups

we are having both sqlserver 2000 and sqlserver 2005 systems.
and we are using idera sqlsafe to backup.
other than restoring the backups,what are the other ways of verifying the backups on regular basis to check whether the backup is good or corrupted.
Look at RESTORE VERIFYONLY in BOL http://www.tradeco.co.uk
RESTORE VERIFYONLY is useful upto some extent as it check to see that the backup set is complete and that all volumes are readable. It does not attempt to verify the structure of the data contained in the backup volumes, hence restore that backup is only best solution. If you are able to restore those backups successfully as and when they are backed up, then that is only most reliable way to ensure it is working or not. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
RESTORE VERIFYONLY improved in sql 2005 compared 2000 but still restore process is the best option as Satya mentioned to make sure it is valid backup.
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.