December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
How Microsoft SQL Server Failover Clustering Works
Put simply, SQL Server 2012 allows failover and failback to or from another node in a cluster. This is an immensely powerful tool for achieving higher availability virtually transparently. SQL Server failover clustering can be fully functional without using the additional AlwaysOn capability. AwaysOn provides database-level failover; clustering is at the server instance level.
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, ...