Loading

SQL Server database

Rigobert GANDE

I’m having problems with my SQL Server databases. The database has switched to the “recovery_pending” mode. This problem occurs once the database is deployed to production. Simply restarting the production server causes the database to change mode.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mukesh Sagar4mo ago
Accepted answer
To chcek the exact root cause of the issue, use the command:

SELECT name, state_desc, recovery_model_desc
FROM sys.databases
WHERE state_desc = 'RECOVERY_PENDING';

Then check SQL Server error log:
- EXEC xp_readerrorlog;
  
  Chcek the root cause, that may be one of these :
- “Operating system error 5 (Access is denied)”
- “Unable to open the physical file”
- “Insufficient disk space”
- “The log cannot be rebuilt”
+1