Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
Ask a Question

Does SQL Server 2019 standard support Always on availability group?

0 like 0 dislike
15k 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 ●159 ●198 ●381
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!
deBUG Community deBUG.to
If you don’t ask, the answer is always NO!
...