0 votes
Hi Folks,

I was just looking at the documentation for dbcc checkdb and I took notice of the REPAIR OPTIONS. It recommends that to repair errors you should restore from backup. To my way of thinking that would defeat the purpose of running the command anyway. If the db was corrupt wouldn't restoring from a good backup fix all your problems anyway? Is there any good doco on this?

Kind Regards
Monday, April 13 2015, 12:47 AM
Share this post:
Responses (1)
  • Accepted Answer

    Monday, April 13 2015, 09:11 AM - #Permalink
    0 votes

    If your recovery model is FULL then you can take the backup the tail of the log and perform restore from the last clean full backup. if only few pages are affected then you have the option of selective restoring of bad pages.

    Thanks & Regards
    The reply is currently minimized Show
Your Reply