May 31, 2021 at 12:12 pm
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?
May 31, 2021 at 12:56 pm
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
May 31, 2021 at 3:20 pm
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