Hi

Cripes, thats never good :)

What DB is it occuring in btw? before we progress any further..

Check the help on the command, and read up on REPAIR_REBUILD option.
I would also run CHECKALLOC on the db without repair options and CHECKCATALOG
just to give you a better picture of whats going on here.

Dont shutdown, attempt a backup first, verify the backup with RESTORE
VERIFYONLY then run the DBCC commands with the repair commands.

If the dbcc commands report no issues after the repair, shutdown the instance
and check your double check your disks.

Cheers

Ck
www.chriskempster.com


MS Sql Server LazyDBA home page