How To Fix Recovery Pending State In SQL Server Database

News Knowledge Base
1

How to fix Recovery Pending State in SQL Server Database?

Issue Description:
An SQL database is considered to be damaged if one or more of its core files are in an inconsistent state. Depending on how severe the damage is, the DB is marked with different states. Some of these states are:

  • Online – If one of the data files is damaged when executing a query or some other operation, the database will remain online and accessible.
  • Suspect – If a database cannot be recovered during the startup of the SQL Server, the database is marked as Suspect.
  • Recovery Pending – If the SQL Server knows that database recovery needs to be run but something is preventing it from starting, the Server marks the DB in ‘Recovery Pending’ state. This is different from the SUSPECT_state because it cannot be said that recovery is going to fail – it just hasn’t started yet.


Resolution:
To fix the Recovery Pending state, follow the below approach:

  1. Check there is enough space in the DB server for log files
  2. Restart the SQL Server Service
  3. Restart Cluster Service
  4. If none of the above works, request the customer to check with DB admin to set DB as emergency and repair it. Please refer below article for details

Read more:

Error Screenshot: