Link to home
Start Free TrialLog in
Avatar of Muhammad Asif
Muhammad Asif

asked on

SQL Standard and Enterprise can be in same Always-On Availability Group?

We have two SQL standard servers with Basic Always-On Availability group. We would like to upgrade them from standard to enterprise and action plan is to failover the database to one server and upgrade the other one.

However, once the SQL server is upgraded from standard to enterprise, can we failover the database to it which part of always-on or i want to ask can two servers one with standard version and other with enterprise can be part always-on?
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Yes, you can.. Just remove the Automatic failover of all Synchronous commit replicas, perform upgrade on Secondary replicas and then do manual failover and then upgrade your current Primary replica..
For more detailed step by step instructions, refer below:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-2017
ASKER CERTIFIED SOLUTION
Avatar of Andrei Fomitchev
Andrei Fomitchev
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial