Several questions concerning data integrity

  • Hello --

    We are running a Full Recovery model on one of our servers, and for some reason, which will be corrected, checking the integrity of the backup was not set up in the Maintenance Plan. I had several questions concerning this issue.

    1. The "Verify backup integrity" option within SQL Studio will be checked off for the Full, Differential, and Transaction log backups. Does this option do a Checksum and/or Cyclical Redundancy Check for the backups?

    2. If a checksum and crc are not done in the previous question, can they be set up within Studio, or do I need to do either within T-SQL?

  • kaplan71 (12/24/2014)


    1. The "Verify backup integrity" option within SQL Studio will be checked off for the Full, Differential, and Transaction log backups. Does this option do a Checksum and/or Cyclical Redundancy Check for the backups?

    It checks the validity of most of the backup header. Nothing more. It's mostly useless alone

    2. If a checksum and crc are not done in the previous question, can they be set up within Studio, or do I need to do either within T-SQL?

    You need to do backups WITH CHECKSUM, and then the Verify command will re-check the backup's checksum. Maintenance plans do not offer this option.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hello --

    Thanks for your reply. I had a follow-up question: How much time would be added to a given backup job if the crc and checksum options were added to the equation?

    Thanks.

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

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