How Microsoft SQL Server Failover Clustering Works
Put simply, SQL Server 2014 allows failover and failback to or from another node in a cluster at the server-instance level. This is an immensely powerful tool for achieving higher availability virtually transparently.
There are two approaches to implementing SQL Server failover clustering: active/passive or active/active modes.
In an active/passive configuration, an instance of SQL Server actively services database requests from one of the nodes in a SQL Server failover cluster (that is, the active node). Another node is idle until, for whatever reason, a failover occurs (to the passive node). With a failover situation, the secondary node (the passive node) takes over all SQL Server resources ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
