Msg 8947, Level 16, State 1, Line 1
Table error: Multiple IAM pages for object ID 349973069, index ID 1, partition ID 72057598823759872, alloc unit ID 72057598842699776 (type In-row data) contain allocations for the same interval. IAM pages (1:396048) and (1:292862).
CHECKDB found 1 allocation errors and 0 consistency errors in table 'linked_project' (object ID 349973069).
CHECKDB found 1 allocation errors and 0 consistency errors in database 'DB_software_factory'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DB_software_factory).
I have no clean backup and the DBCC is not able to repair the error.
I can do a clean install of the SF, but I will need to export/import the projects. Is this possible? Are there other solutions, like replacing the 'linked_project' table?
Best answer by Anne Buit
Without delving deeper into the problem, the easiest way to deal with this is probably to export as much data as possible from the linked_project table. Disable all triggers, constraints and foreign keys, truncate the table and re-insert the exported data.