"IAM Page" Error

[gharabed]

When I try to drop an index on a particular table or try to drop the table itself I get the error:

IAM page (56:6016902) for object ID 821838240 is incorrect. The table ID on page is 273592213; should be 821838240. The entry in sysindexes may be incorrect or the IAM page may contain an error.

When I run a dbcc checktable on this table it just seems to run forever (over three hours before I killed it). How do I resolve this problem? Any ideas?

 

[ptheriault]

You where on the right track by running DBCC CHECKTABLE. You might want to run it with the REPAIR_REBUILD option. This option is the best choice so you don't loose any data. The time it takes depends on how large the table is and how many indexes. Keep in mind that DBCC CHECKTABLE will use a table lock or shared table lock. you might want to let this run over night if you can so not to impact production.

- Paul
- Database performance looks fine, it must be the Network!