What are the limitations of basic availability groups in SQL Server?

Question

But unlike its Enterprise Edition counterpart, there are some limitations. You can only join one database per Basic Availability Group. While you can have an unlimited number of Availability Groups within a replica as your hardware resources permit, you can only have one database in a Basic Availability Group.

What limitations exist for basic availability groups?

Basic availability groups include the following limitations:Limit of two replicas (primary and secondary). ... No read access on secondary replica.No backups on secondary replica.No integrity checks on secondary replicas.

What are the limitations of SQL Server?

SQL Server Express Edition LimitationsThe maximum database size is 10 Gb.No support for the high availability configurations.No support for the disaster recovery configurations.No support for encryption.No support for compression.No support for database mail.Limited support for performance tuning tools.

How many availability groups can be created in SQL Server?

A given instance can host only one availability replica per availability group. However, each instance can be used for many availability groups. A given instance can be either a stand-alone instance or a SQL Server failover cluster instance (FCI).

What is the difference between AlwaysOn failover cluster instances and AlwaysOn availability groups?

An SQL AlwaysOn failover cluster instance provides high availability and disaster recovery at the SQL Server level. AlwaysOn Availability Groups (AAG) provide high availability and disaster recovery at SQL database level.

Expert · Answer