Saturday, October 13, 2007

DBCC and RESTORE VERIFYONY WITH CHECKSUM

If you want to check whether a backup contains any location, structural, or logical integrity problems, you must restore the backup onto a standby SQL Server and run DBCC CHECKDB statements.
Using the RESTORE VERIFYONLY statement is not a guarantee of reliable data restoration-it is merely to check the readability of the file, even with CHECKSUM option.