Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.