How To Fix Recovery Pending State In SQL Server Database

News Knowledge Base
1

How to fix Recovery Pending State in SQL Server Database?

A 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 startup of 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.


To fix Recovery Pending state, follow below approach,

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

Error Screenshot: