Database stuck in recovery mode after server restart

  • Hello,

    We were running a particular update on a huge table and SSMS got stuck, it gave the error "Locked timeout exceeded limit" on the database.

    After doing some search, we decided to do a server restart. The DB in question is coming in "Recovery" mode after restart. Does it recovers on its own or we need to do forceful restore?

  • Pending recovery means that for some reason recovery did not start and the SQL server is waiting for something to happen.  Most times when it happened to me, it was because the storage admin modified something and the server was not able to get to the log files (but I'm sure that there are many other scenarios that can cause this error).  This means that most chances are that you need to check why it can't start the recovery and fix the problem.

    Adi

  • Check the SQL Server log - you will probably see messages related to that database stating it is recovering.  The problem here is that you had a long running transaction that failed and started rolling back - then, while it was rolling back you restarted the server.

    The database cannot be started until that rollback completes.  To find out how long that is going to take - check the SQL Server logs.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply