Can i add SQL 2016 as a new replica to existing SQL 2012 Availability group?
We have SQL 2012 with 1 Primary and 2 Secondaries on WSFC. I want to add SQL 2016 as a new secondary replica to existing cluster
asked Jul 12, 2017 at 02:41 PM in Default
Only as part of a rolling upgrade. You wouldn't be able to have the 2016 instance as read-able, as the moment you bring the database online, it will upgrade the database engine version - then no further logs could be written to it from the 2012 replicas.
answered Jul 12, 2017 at 04:01 PM
Kev Riley ♦♦