Post reply

Urgent Help - Consistency Errors after running CHECKDB

  • December 14, 2010 at 4:29 am

    #232088

    Our Production DB on SQL Server 2008 SP1 (x64) reported some errors this morning

    I have rund CHECKDB with the following results.

    Msg 8929, Level 16, State 1, Line 1

    Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data): Errors found in off-row data with ID 1411842048 owned by data record identified by RID = (1:3717:1)

    Msg 8928, Level 16, State 1, Line 1

    Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data): Page (1:73173) could not be processed. See other errors for details.

    Msg 8939, Level 16, State 98, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data), page (1:73173). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -1.

    Msg 8965, Level 16, State 1, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). The off-row data node at page (1:73173), slot 0, text ID 1411842048 is referenced by page (1:22265), slot 0, but was not seen in the scan.

    CHECKDB found 0 allocation errors and 4 consistency errors in table 'sys.sysobjvalues' (object ID 60).

    CHECKDB found 0 allocation errors and 4 consistency errors in database 'my db'.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (my db)

    I have read through the article http://www.sqlservercentral.com/articles/65804/ but I really need some help from somebody who can understand what these errors are telling me and how I can correct them.

    Thanks for any help

  • December 14, 2010 at 5:14 am

    #1262120

    Also asked: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=154178

    I will be directing replies to the post at SQLTeam.

    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