question

SergeyKotov-1801 avatar image
0 Votes"
SergeyKotov-1801 asked SergeyKotov-1801 commented

Upgrade SQL Always ON group from basic to standart

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-general
image.png (14.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered SergeyKotov-1801 commented

Look at: https://docs.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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.