Post reply

DBCC Check database consistency errors:

  • January 25, 2012 at 6:31 am

    #263247

    Hi Guys.....

    After running dbcc command on this database: dbcc checkdb('ShareWebDb') i got this error message what does it means and how to fix ?

    Msg 7987, Level 16, State 1, Line 1

    System table pre-checks: Object ID 4 has chain linkage mismatch. (1:243)->next = (1:3313), but (1:3313)->prev = (1:3312). Check statement terminated due to unrepairable error.

    DBCC results for 'ShareWebDb'.

    CHECKDB found 0 allocation errors and 0 consistency errors in database 'ShareWebDb'.

    Reply....thnx

  • January 25, 2012 at 7:09 am

    #1438223

    Gail will weigh in I'm sure, as she's had a lot more experience on this, but I'm very sure that unrepairable error. = restore from backup, as it cannot be repaired.

    on my 2005 machine object_id=4 is sysrowsetcolumns

    it's a different object_id in my 2008 machine (which does not have an object_id=4, they are 3 or 5 for exmaple)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 25, 2012 at 7:15 am

    #1438225

    A critical system table is damaged (page pointers are incorrect). Restore from a clean backup.

    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 3 posts - 1 through 2 (of 2 total)

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