We have 3 replica AG setup:
- 2 replicas are in sync/automatic failover
- the other(DR Server, different subnet) in asynchronous/manual mode
- All these replicas were on
SQL Server 2012.
Recently we upgraded the DR server to
SQL Server 2014. Since then we've had a problem with the AG databases in the 2014 instance going into ‘Synchronizing/ in recovery’ state.
The SQL Server error log has the message:
The recovery couldn’t start for the database ‘XYZ’
We tried to create a new database and add it to AG, which it works for the other two 2012 replicas, but on 2014 we see the same issue.
Is there any workaround to fix it, or is upgrading other replicas to 2014 the only available solution?