December 24, 2014 at 8:39 am
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?
December 24, 2014 at 8:41 am
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
December 24, 2014 at 10:18 am
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