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

1. 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

1. 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

Help and Information

Getting SQL Server 2005 Assistance