Results 1 to 2 of 2

Thread: Verify Backups

  1. #1
    Join Date
    Feb 2004
    Alpine Califormia

    Unanswered: Verify Backups

    Hi guys how are you?

    I have a question, lets say I want use the RESTORE VERIFYONLY statement, now I realize this will verify that the backups are readable and can be restored, this will only verify the structure of the backup not the actual data on the pages correct? What if I used CHECKSUM OPTION?

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    If backup checksums are present on the backup media, by default, both the RESTORE and RESTORE VERIFYONLY operations verify the backup checksums and page checksums. If there is no backup checksum, either restore operation proceeds without any verification; this is because without a backup checksum, restore cannot reliably verify page checksums.
    Two options, CHECKSUM and NO_CHECKSUM, allow you to modify how RESTORE and RESTORE VERIFYONLY handle checksum verification, as follows:

      If you explicitly request CHECKSUM for a restore operation and if the backup contains backup checksums, backup checksums and page checksums are both verified, as in the default case. However, if the backup set lacks backup checksums, the restore operation fails with a message indicating that checksums are not present.

      Explicitly disables the default validation of any checksums by the restore operation.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts