5229

Product

Name

Event ID

5229

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

DBCC4_ANTIMATTER_IN_HEAP_OR_CLUSTERED_INDEX

Message

Text

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

contains an anti-matter column, but is not a nonclustered index.

A heap or clustered index contains an antimatter column, but should not.

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-

caching enabled on the disk controller. If you suspect write-caching to be the problem, contact

your hardware vendor.

ﾉ

Expand table