Share via

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 | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 128.9K Reputation points MVP Volunteer Moderator
    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

Your answer

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