Press "Enter" to skip to content

Diagnosing a Database in Recovery Pending State

Jeff Iannucci tells a story:

After receiving the alert, I verified that there were multiple databases on the same instance that were in the “Recovery Pending” state. A review of the SQL Server error log showed that the folder on the L drive was inaccessible, so transaction log files could not be read.

Click through for the troubleshooting steps leading to a happy ending.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.