Back to results for “Replication”
SQL Server › Always On Availability Groups

What is an Always On Availability Group in SQL Server, and what problem does it solve?

Beginner

Answer

An Always On Availability Group is a high availability feature that keeps a copy of one or more databases synchronized across multiple SQL Server instances, so if the main server fails, another server already holding an up to date copy can take over quickly, minimizing downtime for your applications.
-- Simplified concept: primary replica and secondary replicas
-- stay synchronized, with automatic failover configured
CREATE AVAILABILITY GROUP MyAG
FOR DATABASE MyDatabase
REPLICA ON 'ServerA' WITH (...), 'ServerB' WITH (...);
Real-world example An online banking system uses an Always On Availability Group so that if its primary database server suddenly goes offline, a secondary server automatically takes over within seconds, keeping the banking application available to customers.

Common follow-ups: What is the difference between synchronous and asynchronous data movement in an availability group?;How many secondary replicas can an availability group support?