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:
Execute the BACKUP DATABASE statement.
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
Tasks
How to: Specify Whether BACKUP Continue or Stops on Encountering an Error
Concepts
Detecting and Coping with Media Errors
Other Resources
BACKUP (Transact-SQL)
SQL Server Management Studio Tutorial