Export (0) Print
Expand All

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.

  1. When you execute the BACKUP statement, specify CONTINUE_AFTER_ERROR, which instructs BACKUP to continue despite 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).

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

Community Additions

ADD
Show:
© 2014 Microsoft