SCSQL日志备份失败、并且与主副本的连接处于非活动状态
适用场景
- 适用于SQL 4.9的SnapCenter插件(SCSQL)
- SQL Availability Group AlwaysOn (AG)
问题描述
在对SQL AG的主实例和二级实例进行SCSQL备份期间、对其中一个副本进行日志备份失败、并在SMSQL日志中显示以下错误:
System.Data.SqlClient.SqlError: The connection to the primary replica is not active. The command cannot be processed
ErrorCode (-1), ErrorMessage (System.Data.SqlClient.SqlError: The connection to the primary replica is not active. The command cannot be processed.)