SQL Server Standard Edition Always on Configuration

Aditi Das 0 Reputation points

Hi Team,

Please confirm if there is any limitation on number of databases that can be added in AG in SQL Server Standard edition for replication?

Do i need to create 1 AG for 1 DB? if so, then in total how many AGs can be created in SQL Server Standard edition?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,575 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 92,956 Reputation points

    In a Basic Availability Group, you can only have one database.

    You may have more than one AG on the same server. There does not seem to be an upper limit given, but don't have too many. Out of the blue, I would say that you should stay below 50.

    Also see https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver16.

    1 person found this answer helpful.
    0 comments No comments