How many basic availability groups can you have?

Question

You can only join one database per Basic Availability Group. While you can have an unlimited number of Availability Groups within a replica as your hardware resources permit, you can only have one database in a Basic Availability Group.

How many basic availability groups does an instance have?

You can have multiple Basic Availability Groups on the instances, but only 1 database per Basic AG. So if you have 10 databases, you can set up 10 Basic AGs.

How many availability groups can be created in SQL Server?

A given instance can host only one availability replica per availability group. However, each instance can be used for many availability groups. A given instance can be either a stand-alone instance or a SQL Server failover cluster instance (FCI).

What is a basic availability group?

A basic availability group supports a failover environment for a single database. It is created and managed much like traditional (advanced) Always On Availability Groups (SQL Server) with Enterprise Edition. The differences and limitations of basic availability groups are summarized in this document.

How many AlwaysOn availability groups can be configured in always on?

You can have more than one AlwaysOn Availability Group on your instance, but databases cannot belong to more than one group. Not configured for database mirroring.

Expert · Answer