question

rehaan avatar image
rehaan asked

Can i add SQL2016 to SQL2012 AG

Hi friends, 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
clusteralways-onsql2012sql2016
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
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.
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rehaan avatar image rehaan commented ·
HI Kev, Thanks for the response We are planning for upgrade. hence i want to add 2016 as readable secondary. failover 2012 to 2016 to make it primary and then upgrade the other 2012 node to 2016. Can you direct me to any documentation on this please?
0 Likes 0 ·
rehaan avatar image rehaan commented ·
Kev during this process databases on 2016 replica ,will they be in sync with 2012 Primary replica
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
Yes you can have them synchronous
0 Likes 0 ·
rehaan avatar image rehaan commented ·
ThankYou Kev
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.