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 12»»

SOS DB In-Recovery Expand / Collapse
Author
Message
Posted Tuesday, June 18, 2013 8:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 5:37 AM
Points: 55, Visits: 119
I am running SQL Server 2012 on Win 7 machine.
Yesterday, due to extended power failure and other issues, the machine froze.
Now, when I rebooted the machine, the database is In-Recovery mode.
Please help. What do I do?
Post #1464713
Posted Tuesday, June 18, 2013 9:20 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 41,530, Visits: 34,447
The database state (from sys.databases) is RECOVERING?

If so, wait. There's nothing that you can do to magically bring it out of recovering, the recovery process must complete.
The progress of the recovery process will be recorded in the error log.

Do NOT restart SQL, it will start the recovery process over from scratch.
Do NOT try to drop the database or do anything to the database files, at best it'll do nothing at worst it'll leave you needing to restore from backups



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1464729
Posted Tuesday, June 18, 2013 9:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 5:37 AM
Points: 55, Visits: 119
Thanks GilaMonster, but I would rather restore from backup. I have a backup just before the disaster.
Post #1464738
Posted Tuesday, June 18, 2013 10:00 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 41,530, Visits: 34,447
Then drop it and restore, if you're certain it'll be faster and you have all the necessary backups to restore with no data loss.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1464760
Posted Tuesday, June 18, 2013 10:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 5:37 AM
Points: 55, Visits: 119
Thanks, but that's the problem. It does not let me take it offline, detach or drop. It is just stuck with SSMS saying <db Name>(In-Recovery).
Post #1464767
Posted Tuesday, June 18, 2013 10:13 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 41,530, Visits: 34,447
If you're absolutely certain that you can restore from backups, stop the instance, delete the files, start SQL Server, restore from backup.

Make sure you can restore first!



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1464771
Posted Tuesday, June 18, 2013 10:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 5:37 AM
Points: 55, Visits: 119
i am hoping i can create a new db and restore into that. But this would not even let me create a new db.

I got a deadline and need to get this working by hook or crook.
Post #1464774
Posted Tuesday, June 18, 2013 10:23 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
"it would not let me" doesn't help us. Can you please give specific errors or issues and what commands you've run.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1464775
Posted Tuesday, June 18, 2013 10:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 5:37 AM
Points: 55, Visits: 119
The database is in use.
Post #1464782
Posted Tuesday, June 18, 2013 10:44 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 41,530, Visits: 34,447
tinausa (6/18/2013)
The database is in use.


You cannot be connected to the database you're restoring into.

USE MASTER
GO
RESTORE DATABASE ....

and make sure that you don't have another window connecting to that DB.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1464785
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse