How to: Enable or Disable Backup Checksums (Transact-SQL)

This topic explains how to enable or disable backup checksums.

To enable or disable backup checksums:

  1. Execute the BACKUP DATABASE statement.

  2. As part of the options, specify:

    • CHECKSUM, which explicitly requests backup checksums.
    • NO_CHECKSUM, which explicitly disables backup checksums (this is the default behavior).

See Also


How to: Specify Whether BACKUP Continue or Stops on Encountering an Error


Detecting and Coping with Media Errors

Other Resources

BACKUP (Transact-SQL)
SQL Server Management Studio Tutorial

Help and Information

Getting SQL Server 2005 Assistance