SQL Server DBA

Availability Groups operational administration

Question

SYNCHRONIZED vs. SYNCHRONIZING: how should an operator interpret them?

Answer

SYNCHRONIZED: a synchronous-commit secondary is caught up; every committed transaction is hardened there, enabling planned failover without data loss. SYNCHRONIZING: data movement is active. On asynchronous-commit replicas it's the normal steady state even with no backlog; on synchronous-commit replicas it means still catching up, so not yet failover-ready.

This is 1 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples