大家或许会遇到一个Cluster中,3个Nodes挂掉两个的情况,这时剩下的一个Node上的DB就会变成Recovery Pending的状态,从而无法访问。AlwaysOn Group及Replica的状态也会变得不正常,显示Resolving状态。这时,如果没有数据的备份,同时挂掉的两个Nodes也恢复不了,而你又需要使处于Recovery Pending的DB恢复成正常可以访问的状态,你会怎么办呢?这里将探索解决方案。
首先尝试Detach, Take Offline等,不过失败:
Detach或Take Offline时都会报如下错误:
The operation cannot be performed on database "ASRS_F1" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group