August 30, 2012 at 8:11 am
Hi,
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
GO
ALTER DATABASE dbname SET SINGLE_USER
GO
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
August 30, 2012 at 10:19 pm
This was removed by the editor as SPAM
November 29, 2012 at 5:40 am
As you said you don't have any backups it seems to me the issue of mdf corruption. You should go for any third party tool, try Recoveryfix for SQL Database software hope this helps for you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply