Post reply

SCOM DB CheckDB errors

  • September 27, 2010 at 8:18 am

    #229758

    As the subject states, SCOM DB, our latest backup is for 17 September 2010 before the errors were picked up ... I will be running

    DBCC CHECKDB (OperationsManager, REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS

    after hours during an emergency change control to try and recover the DB ...

    What are the chances of further issues???

    Msg 8928, Level 16, State 1, Line 1

    Object ID 1771153355, index ID 2, partition ID 72057594379567104, alloc unit ID 72057594438549504 (type In-row data): Page (1:1092657) could not be processed. See other errors for details.

    Msg 8941, Level 16, State 2, Line 1

    Table error: Object ID 1771153355, index ID 2, partition ID 72057594379567104, alloc unit ID 72057594438549504 (type In-row data), page (1:1092657). Test (sorted .offset <= m_freeData) failed. Slot 106, offset 0x800b is invalid.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 1771153355, index ID 2, partition ID 72057594379567104, alloc unit ID 72057594438549504 (type In-row data). Page (1:1092657) was not seen in the scan although its parent (1:1092592) and previous (1:1092656) refer to it. Check any previous errors.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 1771153355, index ID 2, partition ID 72057594379567104, alloc unit ID 72057594438549504 (type In-row data). Page (1:1092658) is missing a reference from previous page (1:1092657). Possible chain linkage problem.

    CHECKDB found 0 allocation errors and 4 consistency errors in table 'Alert' (object ID 1771153355).

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

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (OperationsManager).

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

  • September 27, 2010 at 9:00 am

    #1227756

    no issues thanks :hehe:

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

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

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