Eric Stimpson (8/28/2012)
In my environ, dbcc table check occurs, I believe due to backup option "checksum" which causes a page checksum calculation on every table's data prior to backup.
Checksum and checktable are two different things. Backups don't run checktable or checkDB.
The backup with checksum recalculates the checksums on each page backed up and then cacluates a checksum over the backup file.
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