What is the recommended process of upgrading Availability Groups
with one Sync Replica from SQL 2014 to 2016?
My understanding is that in-place
upgrades are not really liked among database professionals. Is there a way to avoid in-place
upgrades in Availability Groups
? Is there a possibility to join a 2016 server into an existing 2014 availability group and to failover there, then "kill" one of the other instances and upgrade it? (e.g. by removing/re-installing SQL side-by-side on the same host)
Are there any other upgrade scenarios that we should consider?
The ideal solution would be that we always have 2 online
replicas, and that we don't need to do any in-place
upgrades.