Post reply

Using checksum in backup

  • November 7, 2011 at 8:04 am

    #246336

    We want to use checksum option when using the backup command/operation.

    My question is how we can tell the checksum option actually takes place.

    I compared the backup file that with checksum to the file without backup, but it is hard to tell.

    1. the file sizes are identical.

    2. comparing the contents does help either. b/c every time you do a backup the file is different even you use the same options.

    So again, is there a way to tell the checksum actually takes place.

    Thanks

  • November 7, 2011 at 8:31 am

    #1403984

    hmm.. never noticed that... 🙂

    You can use RESTORE HEADERONLY to check if the backup contains CHECKSUM:

    RESTORE HEADERONLY

    FROM DISK = N'C:\Database\Backup\WithChecksum.bak'

    look for column "HasBackupChecksums".

    Vishal Gajjar
    http://SqlAndMe.com

  • November 7, 2011 at 8:42 am

    #1403995

    Vishal Gajjar

    Thank you very much for quick response. Where is this column? Thanks

  • November 7, 2011 at 8:44 am

    #1403997

    bull49er (11/7/2011)

    Vishal Gajjar

    Thank you very much for quick response. Where is this column? Thanks

    In the output of RESTORE HEADERONLY command

    Vishal Gajjar
    http://SqlAndMe.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply