Checksum is only applied to an updated database when pages are read into cache, changed and written back to disk. Just turning on the CheckSum option makes no change to the pages. The checksum value is only calculated and applied once the page is read into cache, changed and written back to disk.
The only fix for a corrupt page is to delete the page and fix the links
Always use the WITH CHECKSUM option when taking backups if checksum option is on
CONTINUE_AFTER_ERROR option will force backup to do just that. CONTINUE_AFTER_ERROR will also allow a corrupt backup to restore.
Thanks to Paul S. Randal from SQLSkills for these tips. Details at
No comments:
Post a Comment