Post reply

data corruption

  • June 6, 2013 at 4:12 pm

    #278300

    hello experts,

    i executed DBCC CHECKDB command on my 600 GB database and got below error message.

    "found 1 allocation errors and 133891 consistency errors in database *"

    can some one suggest, how severe it is 1 allocation error and 133891 consistency error, and what shud be the action plan.

    please reply as its urgent.

    thanks

  • June 7, 2013 at 3:07 am

    #1622008

    Please run the following and post the full and complete, unedited output here.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Save the output to a text file, zip the file and attach it to your post, it's going to be too large to post directly

    Oh, and in the meantime, locate a clean backup (backup without corruption) as you may need it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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