How can we help you today? How can we help you today?

STOP_ON_ERROR

Please can anyone tell me what exactly the STOP_ON_ERROR parameter of the BACKUP command does?

It is not documented in the help files.

I am wondering if it fails the step and job if there is an error with the backup step, thereby preventing the Transaction Log from being truncated?

Thanks,
Baldcoder.
BaldCoder
0

Comments

1 comment

Sort by
  • petey
    If the option in the help file is not highlighted in gray, it's a SQL Server option. STOP_ON_ERROR is a SQL Server option. From BOL:
    Instructs BACKUP to fail if a checksum does not verify. (This is the default behavior.)

    If a backup contains damaged pages, it is best to repeat the backup operation using an alternate backup that does not contain the errors—for example, a backup taken before the pages were damaged. As a last resort, however, you can restore the damaged backup using the CONTINUE_AFTER_ERROR option of the restore statement and attempt to salvage the data.
    petey
    0

Add comment

Please sign in to leave a comment.