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.
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