Justin Alcorta
asked on
SQL 2014 AG in-place upgrade to SQL 2016
Couple of questions regarding this topic. Setup that I have is 4 nodes in Hyper-V. 2 same location and the others in different datacenters. We use the systems databases for all logins. So will need to migrate them as well.
1. When doing an in-place upgrade on an AG what is the rollback?
2. When manually failing over after the 3 secondary nodes are upgraded what happens?
3. Does it failover instantly or does it take it offline and upgrade?
1. When doing an in-place upgrade on an AG what is the rollback?
2. When manually failing over after the 3 secondary nodes are upgraded what happens?
3. Does it failover instantly or does it take it offline and upgrade?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER