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

Database is in recovery status. Expand / Collapse
Author
Message
Posted Wednesday, March 24, 2010 2:41 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 424, Visits: 1,049
Hi,

Database is in recovery status.
I dont know why it is showing recovery status.
I tried to do detach,offline and drop then every time i am getting error as "The database is in use".But the database is not in use.
Please advice how its bring back to online.

Thanks,
Chari
Post #888747
Posted Wednesday, March 24, 2010 3:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 31, 2010 1:05 PM
Points: 44, Visits: 245
hi,

any errors in errorlog?
Post #888760
Posted Wednesday, March 24, 2010 3:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:49 AM
Points: 1,155, Visits: 4,643
charipg (3/24/2010)
Hi,

Database is in recovery status.
I dont know why it is showing recovery status.
I tried to do detach,offline and drop then every time i am getting error as "The database is in use".But the database is not in use.
Please advice how its bring back to online.

Thanks,
Chari


first why its goes restoring state?(is any one run the restore script)

Check the sql server errorlog,application logs too

The think is someone is using the database that's why its throwing error
find which user is connecting and kill that user using who2 or sysprocesses.




Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #888768
Posted Wednesday, March 24, 2010 4:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
This clearly mentions that Database is recovering. The recovering process is a transient state; where database will automatically become online if the recovery succeeds. In case the recovery fails, the database will become suspect. The database will not be available.

Also you can provide more details how this kind of situation arises?

You have to be patience.

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #888784
Posted Wednesday, March 24, 2010 5:57 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 @ 12:15 PM
Points: 43,017, Visits: 36,179
If you query sys.databases, what's the value for state_desc for this database? Recovering or restoring?


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 #888841
Posted Wednesday, March 24, 2010 6:11 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 424, Visits: 1,049


select * from sys.databases where name = 'dbname'

state_desc = RECOVERING
Post #888853
Posted Wednesday, March 24, 2010 6:28 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 @ 12:15 PM
Points: 43,017, Visits: 36,179
There should be entries in the SQL Server error log saying what's happening with the database and how long recovery will take. What's in the SQL error log?


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 #888869
Posted Wednesday, March 24, 2010 6:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 31, 2010 1:05 PM
Points: 44, Visits: 245
Check the size of the mdf and ldf files. also check if there is enough free space in the drive, where mdf and ldf files are located .....
Post #888878
Posted Wednesday, March 24, 2010 8:58 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 424, Visits: 1,049
The database is in recovery mode since 3months.so i am not able find any logs in sqlserverlog.
There is enough space in the drive.
Post #889500
Posted Wednesday, March 24, 2010 10:13 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 424, Visits: 1,049
no errors in errorlog.
Post #889523
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse