Table error: IAM page (1:8140747)
Hi:
I am shrinking a database (SQL2000 sp3) with following error:
Server: Msg 8968, Level 16, State 10, Line 1
Table error: IAM page (1:8140747) (object ID 2, index ID 255) is out of the range of this database.
after dbcc checkalloc(ABC)
--------------------------
CHECKDB found 1 allocation errors and 255 consistency errors in table 'sysindexes' (object ID 2).
repair_allow_data_loss is the minimum repair level for the errors found (TollFree ).
I have repaired user tables before. But this time is pointing to a system table.
of course, having a backup before repairing
is there other way for a planB if repairing fall?
my planC is: generate a script for all the DB table index creation. drop all the indexes, then dbcc checkalloc again to see still with above error. then, recreate indexes.
thanks
David