Share via

Upgrade SQL Always ON group from basic to standart

Sergey Kotov 21 Reputation points
2021-02-21T11:34:14.503+00:00

I have two SQL servers Standard Edition with a basic Always ON availability group.
I have updated the server to Enterprise Edition. But i can't upgrade existed availability group from basic. The checkbox "Basic Availability Group" is not accessible
70280-image.png

SQL Server | Other
0 comments
Answer accepted by question author
  1. Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator
    2021-02-21T11:54:01.76+00:00

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

    It includes this point:

    Basic availability groups cannot be upgraded to advanced availability groups. The group must be dropped and re-added to a group that contains servers running only SQL Server 2016 Enterprise Edition.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.