Share via

Basic Availabilty

Vishu 1,556 Reputation points
2021-01-29T16:02:21.73+00:00

Dear Experts,

Can you please help with the fact that does SQL 2019 Standard edition basic availability group support more than one databases i.e. one database per availability group. This way if there are 3 databases - 3 availability group's can be created , one per database and have three different failovers.

If the above is true , is there any MS link for the same

Also does the basic and advanced availability have any difference in terms of failover

Thanks

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,851 questions
0 comments
Accepted answer
  1. Sean Gallardy - MSFT 1,886 Reputation points Microsoft Employee
    2021-01-29T22:38:57.117+00:00

    Can you please help with the fact that does SQL 2019 Standard edition basic availability group support more than one databases i.e. one database per availability group. This way if there are 3 databases - 3 availability group's can be created , one per database and have three different failovers.

    You're correct, that's exactly how it works. Enterprise Edition allows you to remove the one database to one AG barrier so that you can have multiple databases that all fail over together. Another option if you wanted to stay on Standard Edition and have all the databases fail over together is to use a FCI.

    If the above is true , is there any MS link for the same

    Closest thing you're going to see Doc'd is here.

    Also does the basic and advanced availability have any difference in terms of failover

    In terms of failover conditions, no. In terms of failover options, yes, as Enterprise Edition can use Distributed AGs.

    1 person found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alex Bykovskyi 1,831 Reputation points
    2021-01-30T23:22:13.907+00:00

    Hey,

    Just to add, you can choose either Basic Availability Groups or FCI with Standard edition. Both have its pros and cons. The following article might help:
    https://www.starwindsoftware.com/resource-library/sql-server-failover-cluster-instance-vs-basic-availability-group/

    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
  2. Vishu 1,556 Reputation points
    2021-01-31T04:52:21.537+00:00

    Thanks for the confirmation, but can we have an fci on aws

    0 comments
  3. Vishu 1,556 Reputation points
    2021-01-31T06:13:45.93+00:00

    Is it possible to setup a SQL failover cluster on aws for a standard edition

  4. Cris Zhan-MSFT 6,606 Reputation points
    2021-02-01T07:22:10.14+00:00

    Hi,

    A basic availability group supports two replicas, with one database. You can create multiple BAGs, one database per availability group.

    If you need multiple databases together for failover, then you need to use Enterprise Edition or FCI.

    Note that for the Standard Edition, SQL Server Failover Cluster Instance(FCI) only supports two nodes.

    >Is it possible to setup a SQL failover cluster on aws for a standard edition

    For this issue, please contact with aws support.

    The Windows Server Failover Clustering (WSFC) is the basis of Always On availability groups and SQL Server failover cluster instances.

    0 comments