Sql STD always on

Question

Hi
Is there any way to apply more than a single DB replication in SQL Cluster Always On standard edition?
Is there a way to implement more then one AG (Availability Group) per instance and if so can we utilize two AGs on a single volume (using a single volume for two databases each in a separate AG replication) ?
Thanks
Nitzan

Answer 1

If you read the topic Basic Always On availability groups for a single database, you will find this sentence:

You may have multiple Basic availability groups connected to a single instance of SQL Server.

So the answer is: Yes.

Answer 2

Hi Thanks for the prompt reply, I'll forward it to my customer!
B.R
Nitzan

Answer 3

Hey,

As mentioned, it is possible to have multiple BAG connected to a SQL Server instance. As an alternative you can consider building SQL FCI using a shared storage of your choice (S2D or StarWind VSAN as examples). Following comparison should help:
https://www.starwindsoftware.com/blog/sql-server-failover-cluster-instance-and-basic-availability-group-features-comparison

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose