Export (0) Print
Expand All
Expand Minimize

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

  • 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).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft