We had a server reboot the other night and it seams to have corrupted several files. I have a database in SQL Express that is corrupt and one in regular SQL that was labeled suspect. I would tthis on a web site for fixing suspect DB's.

ALTER DATABASE koochdata SET EMERGENCY
DBCC checkdb('koochdata')
ALTER DATABASE koochdata SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('koochdata', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE koochdata SET MULTI_USER

When I issue these one at a time I can see in the log files that the DB is changing status but when I run the dbcc commands I get this result.

Msg 922, Level 14, State 1, Line 1
Database 'KoochData' is being recovered. Waiting until recovery is finished.

Query completed with errors

I haven't been able to find msg 922 anywhere. Is there a reason that dbcc doesn't want to work? It didn't leave a message in the log file just the changes in the DB status.

Also. Can I use the same procedure in Sqlserver express?

Thank you in advance.

Quinn