Table error: IAM page (1:8140747)

[DLu]

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

[rmiao]

I'm with your plan c.

[DLu]

thanks ramio,
I plan to do it this Sunday with minimum interferrring from other appl connections.

-D