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 in Recovery Pending State Expand / Collapse
Author
Message
Posted Tuesday, April 9, 2013 1:08 PM


SSC-Forever

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

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 40,208, Visits: 36,617
ericjorg (4/9/2013)
GilaMonster (4/9/2013)

Good way to destroy a database...
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/


Yes, that is exactly right. In my case, this was a test database and the logfile was created in a different version of SQL server, so it was safe to wipe it out.


Very exceptional situation then. Normally deleting the log of a database that's in recovery will make the database recovery_pending, deleting the log of a database that's recovery pending will result in it still being in the recovery pending state.



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 #1440513
Posted Thursday, April 11, 2013 5:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 11, 2013 5:07 AM
Points: 1, Visits: 0
Hi all,

My database is showing as RECOVERY_PENDING any one can help me ?
Post #1441185
Posted Thursday, April 11, 2013 5:15 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: Yesterday @ 8:19 AM
Points: 40,208, Visits: 36,617
Please post your question in a new thread and include as much detail as possible about what events preceded the problem and what errors are in the 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 #1441188
Posted Monday, June 10, 2013 10:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 7:47 AM
Points: 9, Visits: 151
check the permssions on the database files after confirming they exist in the location expected. you may find that the permission has been damaged. Re-add the SQL Server service account to the file/security with full rights, run the offline/online commands and it should come onlin.
Post #1461644
Posted Thursday, July 11, 2013 9:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:00 PM
Points: 1,354, Visits: 1,752
Check for the location where your ldf and mdf files are and As long as you have them try doing a detach/attach and it should bring the database to a normal state.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Post #1472666
Posted Thursday, July 11, 2013 10:16 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: Yesterday @ 8:19 AM
Points: 40,208, Visits: 36,617
Sapen (7/11/2013)
Check for the location where your ldf and mdf files are and As long as you have them try doing a detach/attach and it should bring the database to a normal state.


No.

A database that is in any suspect/recovery_pending status should not be detached. A database so detached may well not reattach, meaning you've gone from a database in the recovery_pending state that you may be able to fis, to a bunch of files in the file system that you can't do much with.



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 #1472683
Posted Tuesday, July 16, 2013 10:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 6, 2014 11:59 PM
Points: 19, Visits: 344


By running the command in your post I found out that my .mdf and .ldf files were read only so it did help me.
Thank you!
Post #1474369
Posted Thursday, February 13, 2014 9:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 16, 2014 3:16 PM
Points: 8, Visits: 249
Hi Gail,

i too am facing the same issue that three of my databases are in 'recovery pending' mode. I have checked the luns that host these database, they are all up and running normally with sufficient disk spaces. the datafile and logfile has not been changed since last month. Do you have any suggestions?

regards,
danny
Post #1541308
Posted Thursday, February 13, 2014 12:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 12:08 PM
Points: 6, Visits: 35
Did you try restarting the SQL Server Agent service under control panel > administrative tools > services ?
Worked for me.
Post #1541378
Posted Friday, May 23, 2014 2:16 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: Yesterday @ 8:19 AM
Points: 40,208, Visits: 36,617
.


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 #1573919
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse