8974

Product

Name

Event ID

8974

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

DBCC3_OFF_ROW_DATA_NODE_HAS_TWO_PARENTS

Message

Text

Table error: Object ID O_ID, index ID I_ID, partition ID PN_ID, alloc unit ID A_ID (type TYPE).

The off-row data node at page P_ID1, slot S_ID1, text ID TEXT_ID is pointed to by page

P_ID2, slot S_ID2 and by page P_ID3, slot P_ID3.

An off-row data node has two data or index records that list it as a child node. A node can have

only one parent node.

Run hardware diagnostics and correct any problems. Also examine the Microsoft Windows

system and application logs and the SQL Server error log to see whether the error occurred as

the result of hardware failure. Fix any hardware-related problems that are contained in the logs.

If you have persistent data corruption problems, try to swap out different hardware

components to isolate the problem. Check to make sure that the system does not have write-

ﾉ

Expand table