<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server Express
»
Database stuck in RECOVERY_PENDING state
Database stuck in RECOVERY_PENDING state
Rate Topic
Display Mode
Topic Options
Author
Message
gdhillon
gdhillon
Posted Thursday, August 30, 2012 8:11 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, February 01, 2013 9:36 AM
Points: 76,
Visits: 34
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
prettsons
prettsons
Posted Thursday, August 30, 2012 10:19 PM
SSC Journeyman
Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 99,
Visits: 1,036
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
johnwebsoft
johnwebsoft
Posted Thursday, November 29, 2012 5:40 AM
Forum 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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
