September 27, 2010 at 8:18 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy