Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database stuck in RECOVERY_PENDING state Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 8:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 26, 2013 5:15 PM
Points: 76, Visits: 36
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
Post #1352250
Posted Thursday, August 30, 2012 10:19 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:10 AM
Points: 112, Visits: 1,207
If you don't have backup then you should use third party SQL Recovery Software to repair corrupt SQL Server database mdf file. Search on Google about these software.

SQL Database Recovery Expert
Post #1352581
Posted Thursday, November 29, 2012 5:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 2:47 AM
Points: 5, Visits: 9
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.
Post #1390458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse