How to: Specify Whether BACKUP Continue or Stops on Encountering an Error
BACKUP supports two options for the handling of errors. By default backup stops on errors.
To continue on encountering an error
- When you execute the BACKUP statement, specify CONTINUE_AFTER_ERROR, which instructs BACKUP to continue despite encountering an error.
To explicitly stop on encountering an error
- When you execute the BACKUP statement, specify STOP_ON_ERROR, which instructs BACKUP to stop on encountering an error (this is the default).
See Also
Tasks
How to: Enable or Disable Backup Checksums (Transact-SQL)
Concepts
Detecting and Coping with Media Errors
Other Resources
BACKUP (Transact-SQL)
SQL Server Management Studio Tutorial