Failure of a Node
As you can see in Figure 5.24 one of the nodes in the SQL cluster has failed (COLTST3 in this case). As you can also see in Cluster Administrator, the COLTST3 node item group has a “red X” on it to indicate this failure. Also note that the state of the resources on COLTST1 are “Online Pending”! In other words, these resources are in the middle of failing over to this node. As they come up successfully, the “Online Pending” turns to “Online.”
In addition, the failure of a node (for any reason) is also written to the system event log.
Figure 5.25 shows the event ...
Get Microsoft® SQL Server High Availability 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.
