Citrix Provisioning 2112

SQL basic availability groups

July 5, 2024

Contributed by:

C L

A basic availability group supports a failover environment containing a single database. SQL basic availability groups are configured the same way as SQL Always-On High Availability groups, with the following differences:

Limit of two replicas (primary and secondary).
No read access on secondary replica.
No backups on secondary replica.
No integrity checks on secondary replicas.
Support for one availability database.
Basic availability groups cannot be upgraded to advanced availability groups. The group must be dropped and readded to a group that contains servers running only SQL Server 2016 Enterprise Edition.
Basic availability groups are only supported for Standard Edition servers.
Basic availability groups cannot be part of a distributed availability group.

Tip:

For multi-subnet environments, see Enable SQL Always On multi-subnet failover.

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

SQL basic availability groups

July 5, 2024

Contributed by:

C L

July 5, 2024

Contributed by:

C L

SQL basic availability groups

In this article