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