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.