-
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
-
Last edited by rmiao; 12-06-2007 at 04:15 PM.
-
thanks ramio,
I plan to do it this Sunday with minimum interferrring from other appl connections.
-D
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|