Sdílet prostřednictvím


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