Question :
Running DBCC CHECKDB (dbname) WITH NO_INFOMSGS, ALL_ERRORMSGS
results in this error:
Table error:
Multiple IAM pages for object ID 813245952, index ID 1,
partition ID 72057594073972736, alloc unit ID 72057594083213312 (type
In-row data) contain allocations for the same interval. IAM pages
(1:4611577) and (1:2040821). CHECKDB found 1 allocation errors and 0
consistency errors in table ‘tablename’ (object ID 813245952). CHECKDB
found 1 allocation errors and 0 consistency errors in database
‘dbname’. repair_allow_data_loss is the minimum repair level for the
errors found by DBCC CHECKDB (dbname).
Has anyone experienced this issue before and have a solution for repair?
Note:- I have not run the statement with repair_allow_data_loss
yet.
Answer :
Several years after op. We ran into this error on SQL Server 2014.
Rebuilding the clustered Index on the table fixed the error
ALTER INDEX pk_table ON dbo.table REBUILD WITH (ONLINE = OFF)
after that DBCC CHECKDB (MyDatabase) ran with no errors.