Fail Over to Another Node
As you can see in Figure 42.25, before the SQL Server fails over to the other node, a stern “Please confirm action” is required to complete this action. You must realize that client connections will be broken for any inflight transactions that are currently processing. Be careful here.
FIGURE 42.25 Failing over from USPETSDSQLTST01 to USPETSDSQLTST02, confirming action!
In addition, the failure, move, and taking offline of a node is also written to the System event log.
The next section illustrates what this effect has on a typical client connection point of view.
Congratulations! You are now up and running, with your ...
Get Microsoft® SQL Server 2012 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.
