• Backups do not automatically fail. You have to explicitly add the option to the backup statement to check the checksums. Maintenance plans don't allow that option and most people don't add that option to their backups.

    Plus backup with checksum is in no way a replacement for checkDB. It's better than nothing, but you need to do regular integrity checks if you want to detect corruption early enough to do something about it.

    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