Sql STD always on

Nitzan Bakman 46 Reputation points
2021-08-15T07:33:00.497+00:00

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

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

2 additional answers

Sort by: Most helpful
  1. Nitzan Bakman 46 Reputation points
    2021-08-15T10:17:07.66+00:00

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

    1 person found this answer helpful.
    0 comments No comments

  2. Alex Bykovskyi 1,821 Reputation points
    2021-08-15T11:45:13.08+00:00

    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

    0 comments No comments