Sysindex corrupted!

[SQLSquirrel]

Oh no! I have just run a DBCC CHECKALLOC (dbname) and encountered the following messages on one of our largest SQLServer 7.0 databases.

Server: Msg 8968, Level 16, State 10, Line 1
Table Corrupt: IAM page (1:892478) (object ID 2, index ID 255) is out of the range of this database.
DBCC results for 'dbname'.
***************************************************************
Table sysindexes Object ID 2.
Index ID 1 FirstIAM (1:12) Root (1:13) Dpages 20 Sort 0.
Data level 1. 21 data pages in 5 extents.
Index ID 255 FirstIAM (1:28) Root (1:16) Dpages 0 Sort 0.
Index ID 255. 182 index pages in 42 extents.
Total number of extents is 47.
CHECKALLOC found 1 allocation errors and 0 consistency errors in table 'sysindexes' (object ID 2).
***************************************************************

I removed all the good messages!

How do I fix this? and can I do it harmlessly while users are connected?

Any thoughts?

Many thanks

Rob

 

[JayKusch]

Try running DBCC CHECKDB (dbname) to see what options you are affored to correct the issue.

Thanks

J. Kusch