Tuesday, January 21, 2014

Database in Recovery Pending in SQL Server 2012 Alwayson Availability


Database in Recovery Pending in SQL Server 2012 Alwayson Availability

After performing reboot of primary server the primary replica database moved to "Recovery Pending" state and the other replicas become unusable.
While troubleshooting the issue we identified that Availability group is offline, to bring the Availability group to online we tried failover but we could not able to do that becoz of primary is not online, as a second option we tried to bring the cluster resource online but the cluster manager doesnt allow to bring the resource online.


As suggested by BOL the possible solution for the issue is restarted the server and verified that the availability group recovers to a healthy state.

1 comment:

  1. This type of major issues can be solve by taking simple and reliable actions must read this article http://www.sqlrecoverysoftware.net/blog/sql-database-in-recovery-mode.html

    ReplyDelete