SQL Server 2008 Books Online (October 2009)
How to: Specify Whether BACKUP Continues or Stops upon Encountering an Error (Transact-SQL)

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 During Backup and Restore

Other Resources

BACKUP (Transact-SQL)
Tutorials

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker