SQL basic availability groups
A basic availability group supports a failover environment containing a single database. SQL basic availability groups are configured the same way as SQLAlways-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, seeEnable SQL Always On multi-subnet failover.
SQL basic availability groups
In this article
Copied!
Failed!