I have recently encountered an issue where one of the databases suddenly moved to Recovery Pending status after SQL Server fail-over.
I checked the database and it is in Recovery Pending status. Recovery Pending means that recovery cannot be started. Until the cause is fixed, recovery cannot run and the database cannot come online. I then checked the drives in the server and all drives are accessible.Then
Just i took database offline and bring back to online and database is automatically recovered.
OR
if multiple database are in recovery pending after SQL Fail over or SQL Server Restart..
I had to restart the SQL Server service manually and the database is automatically recovered.
Is this on AlwaysOn?
ReplyDeleteIf yes, it is to do with the Cluster service. If cluster service doesn't come up, the databases will not go past recovery pending state.