liveBook · Manning

Basic availability group

As explained in 100 SQL Server Mistakes and How to Avoid Them

A Basic Availability Group is a limited SQL Server availability-group feature supporting one replica that remains inactive until failover.

Mistake: choosing Enterprise edition automatically when an application requests availability groups. Standard edition can provide a Basic Availability Group when one replica is sufficient. section 8.5

Check these limits before selecting the edition:

  • Supports one replica, configured as synchronous or asynchronous. section 8.5
  • Keeps the replica inactive until failover. section 8.5
  • Does not support readable secondaries, backups on the secondary, or integrity checks on the secondary. section 8.5
  • Avoids Enterprise edition when those advanced capabilities are unnecessary. section 8.5

MagicChoc

MagicChoc requires availability groups with a single synchronous replica. Because Basic Availability Groups meet that requirement, Enterprise edition adds no necessary availability-group capability. section 8.5

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes
Defines replica modes and operational restrictions, but defers broader availability-group treatment.
Examples
Uses MagicChoc's single synchronous replica requirement as the deciding example.
What you can do after
Evaluate whether Standard edition satisfies an application's availability-group requirements.
How it connects
Connects availability groups with replicas, failover, readable secondaries, backup on secondary, and integrity checks.
Cover of 100 SQL Server Mistakes and How to Avoid Them
liveBookmanning.com
Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Related concepts

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.