Answer
AG consists of primary replica, secondary replicas, listener, and modes (sync/async). Provides HA, DR, and readable secondaries.
Quick Answer
AlwaysOn AG replicates databases from a primary replica to one or more secondary replicas using log shipping internally. Supports synchronous (zero data loss, needed for automatic failover) and asynchronous (lower latency for distant replicas). Secondaries can serve reads, backups, and reporting to offload the primary.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ