You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

Microsoft SQL Always On Availability Group is effectively a SQL mirroring cluster. 

In a Mirroring Cluster, there is an active SQL database server and a passive database server. When the active database server is down for some reason, the cluster will fail over to the passive database server, and the passive database will become the active database server. 

In a Mirroring Cluster, only one database server is active at one time and the database operation is served from the active server only. In principle, data change in the active database is copied to the passive database in real time. 

In a Microsoft SQL Always On Availability Group, there is one single primary replica, aka, the active database, and up to 8 secondary replicas, aka, the passive databases.


  • No labels