This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 92%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
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?
Hi @Aditi Das
You can take a look at the answer below. If it helps you, please accept it.
Hi @Aditi Das
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
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.