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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,055 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 103.2K Reputation points MVP
    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