alwayson with mixed SQL server editions

agepeder 271 Reputation points
2023-04-17T13:16:00.8433333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,896 questions
0 comments No comments
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 16,451 Reputation points
    2023-04-18T02:16:24.9633333+00:00

    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.

    User's image

    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".

    0 comments No comments

0 additional answers

Sort by: Most helpful