• free_mascot (4/11/2014)


    If you think that your backup is corrupt you can use RESTORE VERIFYONLY to check if the backup is good?

    Which will check just the header unless your backup is done with checksum. If your backup was done with checksum then verify only will redo the checksum validation and check the header. But, it doesn't check all of the header, so you can still have a bad backup after running checksum and verifyonly. The only way to ensure you have a good backup is to run a restore.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning