Alwayson辅助副本数据库处于恢复/恢复状态 [英] Alwayson secondary replica database in reverting/in recovery state

问题描述

我们有一个SQL Server 2016 两个节点的alwayson组，当我们进行故障转移时，新的辅助数据库更改为恢复/处于恢复状态，这是可以理解的，因为有很长的事务需要在故障转移时回滚，但是在这段时间内是
，只读应用程序仍尝试连接到新的辅助节点，但无法打开数据库，这是不期望的。由于数据库没有同步，不应该将连接定向到新的主节点吗？

We have a SQL Server 2016  two node alwayson group, when we do a failover, the new secondary database changed to reverting/ in recovery state, this is understandable since there are long transactions which needs to be rolled back when fails over, however, during this time, read-only applications still tries to connected to the new secondary, but failed to open the database, this is not expected. Since the database is not synchronizing, shouldn't the connections be directed to the new primary node?

推荐答案

首先，检查错误日志并阅读每个阶段。 

First of all, check the error log and read each and every phase. 

请尝试以下操作：

1。重新启动SQL Server

1. Restart SQL Server

2。离线和在线数据

3。从备份恢复数据库

3. Restore your database from backup

这篇关于Alwayson辅助副本数据库处于恢复/恢复状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！