Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
13.7k views
in SQL Server by 16 16 22
I am wondering if I can use the SQL Server 2019 standard edition to use Always on availability group or this feature is only ssupported in SQL Server 2019 Enterprise Edition?

1 Answer

1 like 0 dislike
by 98 167 336
selected by
 
Best answer

Does SQL Server Standard Edition support the Always-on Availability Group?

As a short answer: NO, the SQL Server Standard Edition DOESN'T support Always On availability groups.

SQL Server 2019 Standard Edition only supports the Basic Availability Group that supports two replicas, with one database.

Which SQL Server Editions support Always On Availability Groups?

The Always On Availability Groups feature is only supported in SQL Server Enterprise Edition.

SQL Server Edition that supports Always On Availability Groups

Note: SQL Server 2019 Standard and SQL Server 2019 Enterprise Edition support Always On failover cluster instances.
For more details, Please check Editions and supported features of SQL Server 2019 and check Failover Clustering and Always On Availability Groups

by 16 16 22
0 0
Thanks for the confirmation!
If you don’t ask, the answer is always NO!
...