May 19, 2018 at 11:33 am
Comments posted to this topic are about the item Corrupted Backups
May 19, 2018 at 11:18 pm
Good question to start the week thanks Steve.
...
May 20, 2018 at 3:28 pm
I'm not sure that CONTINE_AFTER_ERROR is going to help, as if there are torn pages or page checksum errors the backup can't deliver uncorrupted data for the pages affected. And CONTINUE_AFTER_ERROR is not documented (in BOL for SQL Server 17) as having any effect on what happens other that with that sort of error.
So I might try to get a backup of the transaction log only and apply it to my last good backup (a backup is good if all of (a) it has been restored restored to test it and (b) dbbc_checkdb has been run on the restored database with ALL_ERRORMSGS and reported no errors and (c) a set of tests used in checking the functionality of the database as part of develpment and test has been successfully run on the restored database).
Tom
May 21, 2018 at 2:38 am
have only had to do this once; that was due to issues caused by failing hardware.
that was a nightmare, as not all the data was backed up (corrupt pages were ignored).
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply