DBCC CHECKDB (dbname) WITH NO_INFOMSGS, ALL_ERRORMSGS results in this 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
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.