x

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

more ▼

asked Jul 12 at 02:41 PM in Default

avatar image

rehaan
81 1 3 8

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jul 12 at 04:01 PM

avatar image

Kev Riley ♦♦
65.8k 48 63 81

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?

Jul 12 at 04:08 PM rehaan

Kev

during this process databases on 2016 replica ,will they be in sync with 2012 Primary replica

Jul 13 at 09:41 AM rehaan

Yes you can have them synchronous

Jul 13 at 09:44 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x109
x45
x25
x3

asked: Jul 12 at 02:41 PM

Seen: 29 times

Last Updated: Jul 13 at 09:44 AM

Copyright 2017 Redgate Software. Privacy Policy