Forums

Subscribe via email Subscribe via email
Subscribe via rss
Guest
or Ask a Question
Add a reply View Replies (1) →
Holger Wald
Holger Wald
Offline

REPAIRING A corrupt sql database

Resolved
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
In Database
Monday, April 13 2015, 12:47 AM
Subscribe via email
Share this post:
Responses (1)

  • Accepted Answer

    dazy Parker
    dazy Parker
    Offline
    Monday, April 13 2015, 09:11 AM - #Permalink
    Resolved
    0 votes
    Hi,

    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