I have client who sql express installation hosting search database for sharepoint search. they informed yesterday that search not working and I found the search database in SUSPECT state.
I tried put the database in Emergency mode and then to Single User mode in order to run
ALTER DATABASE dbname SET EMERGENCY
ALTER DATABASE dbname SET SINGLE_USER
DBCC CheckDB ('dbname', REPAIR_ALLOW_DATA_LOSS)
but I'm getting the message
''dbname is being recovered. wait until recovery is finished"
This yesterday afternoon, even after 16 hours , I'm getting same message. I tried the restarting SQL services but didn't help
it complaining the corruption is in .mdf file which 300mb in size and Log is 8Gb in size
They don't have any backups
Thanks in Advance