Post reply

corruption in database : what do next

  • August 31, 2019 at 12:17 pm

    #3676024

    hi

    What steps should be taken once corruption has been identified through dbcc ckecdb command .I mean when mnmgt asks what amount of data would be lost ?? then what should be we proceed ahead

    I want to know steps in identifying corruption in database

    Want to identity corrupt pages in it and amount of data that would be lost

    And links ,videos would be appreciated

    Thanks and regards

     

     

     

     

     

  • September 1, 2019 at 2:42 am

    #3676116

    Here's one of the best links on the subject by one of the smartest people I know on the subject.  Don't do ANYTHING until you've read the whole article and then carefully plan and take the steps in the article.

    https://www.sqlservercentral.com/articles/help-my-database-is-corrupt-now-what

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 21, 2019 at 7:30 am

    #3682223

    Hi jeff

    Thanks for replay and actually i had went through links before positing here.

    I was more asking about how to troubleshoot like on which page there is corruption is data page or index page and how much amount of data has been affected...

    how to details regarding it

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply