STOP_ON_ERROR

BaldCoderBaldCoder Posts: 7
edited August 16, 2008 9:42AM in SQL Backup Previous Versions
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.

Comments

  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.