Tac11 (12/18/2014)
I know both have toll. what would you do on production db backup? only CHECKSUM? CHECKSUM AND RESTORE VERIFYONLY? OR VERIFYONLY?
There are caveats to all this, but the article I link above is what I do on production systems, CHECKSUM, VERIFYONLY, DBCC and, where possible, a full restore. All of it. I would only change this if I could demonstrate that any part of it was causing the system to slow down through specific wait statistics.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning