SQL Server Standard Edition Always on Configuration

Aditi Das 0 Reputation points
2023-04-27T06:01:33.82+00:00

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.
14,137 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 113.3K Reputation points MVP
    2023-04-27T20:58:15.0933333+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.