Home Forums SQL Server 2008 SQL Server 2008 - General Checking Backup Files RE: Checking Backup Files

  • December 13, 2012 at 1:30 am

    #1568191

    raotor (12/12/2012)

    Ninja's_RGR'us (12/12/2012)

    There's only 1 valid test.

    FULL restore, including diffs and logs.

    THEN run checkDB.

    Now you know you're good.

    Once that's done you can't move the files because they could get corrupted in the transfer. Of course it could still happen sittin on the disk. So yes, if you can, retest old backups every once in a while.

    Granted.

    But, if you can't actually restore, then what's the next best thing?

    Then use checksum:

    BACKUP DATABASE test

    TO DISK = 'd:\test_checksum.bak'

    WITH CHECKSUM, INIT;

    RESTORE VERIFYONLY

    From disk = 'd:\test_checksum.bak'

    WITH CHECKSUM