Always On Basic Availability Groups

Question

Hi

In standard version of SQL 2019, can we create multiple Basic availability groups with their own listener? We have 4 independent databases and want to know if we can create 4 basic availability groups, 2 basic AG primary on server A and 2 basic AG primary on Server B ?

Best regards

Answer 1

Hi @Mohamed B ,

> Do you know how many Basic availability groups we can create?

Like the traditional (advanced) Always On Availability Groups with Enterprise Edition, Basic Always On availability groups does not have a specific limit on the number of creation.

In theory, there is no limit to the availability groups that can be created on an instance, but generally it is not recommended to exceed 10. Of course, whether more availability groups should be created depends on the possible workload and actual servers configuration.

The differences and limitations of basic availability groups are summarized in following document.
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver15

Answer 2

Hi @Mohamed B ,

>In standard version of SQL 2019, can we create multiple Basic availability groups with their own listener?...

Yes, you can. This configuration is completely feasible, just try it.

Best Regards,
Cris