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.”

Figure 5.24. Failed node—Cluster Administrator.

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.