Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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