STOP_ON_ERROR

BaldCoder

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.

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.