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