| How can we decide the active and passive nodes in SQL Server?
To check this we will open Cluster administrator checks and then check Sql Server group where we can see the current owner. And here current owner is the active node. And rest other nodes are passive. Because at one time only one node can be active and must be in the passive mode in a two mode. | | |