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

Tasks

How to: Specify Whether BACKUP Continues or Stops upon Encountering an Error (Transact-SQL)

Reference

BACKUP (Transact-SQL)

Concepts

Detecting and Coping with Media Errors During Backup and Restore

Tutorials