TechNet
Expand All
This documentation is archived and is not being maintained.

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

Show:
© 2016 Microsoft