alwayson with mixed SQL server editions

Question

Hi, Is mixing SQL server editions in an alwayson setup a supported scenario ? If yes - would it limit any available features in enterpise edition ?

Answer 1

Hi @agepeder ,

In an Always On Availability Group setup in Microsoft SQL Server, it is not supported to mix different editions of SQL Server. This means that all replicas, including the primary and secondary replicas, must be running either the Standard Edition or the Enterprise Edition of SQL Server, and they must be of the same version.

Mixing different editions of SQL Server in an Always On Availability Group setup would not be a supported scenario and could result in unexpected behavior, limitations, and potential loss of features. For example, if you have an Availability Group with a primary replica running SQL Server Enterprise Edition and a secondary replica running SQL Server Standard Edition, you may encounter limitations on the secondary replica due to the lower feature set of the Standard Edition, which could impact the availability and performance of your database system.

There are some differences between the Standard Edition of AG and the Enterprise Edition of AG. The Standard Edition has some limitations.

Here is a document about Basic Always On availability groups for a single database:

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver16

In addition, please refer to this similar thread: https://dba.stackexchange.com/questions/126558/mixed-editions-in-availability-group

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".