Fail Over to Another Node
If the current “active” node fails, the SQL Cluster will automatically fail over to the other node providing high availability at the SQL Server Instance level (as we wanted). We can also manually fail over a node or evict a node from a SQL Server cluster configuration. In the next section, we will simply stop the SQLFOUR Server to simulate a server crash and show you the effects of a client connection to our clustered server. You must realize that client connections will be broken for any inflight transactions that are currently processing. Be careful here.
In addition, the failure, move, and taking offline of a node is also written to the System event log.
Congratulations! You are now up and running, with your SQL ...
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.
