Sysindex table corruption

[SQLSquirrel]

Oh no! I have just run a DBCC CHECKALLOC (dbname) and encountered the following messages on one of our largest 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

 

[SQLSquirrel]

Forgot to mention it's on SQLServer 7.0

 

[TysonLPrice]

I'm not a DBA by any means but Google says head for the back ups!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56049