Link to home
Start Free TrialLog in
Avatar of Teoman Sahin
Teoman Sahin

asked on

finding the active node in Failover Cluster

I am looking at the Windows 2012 Server and sql server 2012 is installed on this server..and I am confused about which node is active? when I look at the Failover Cluster manager,I see the Cluster name and Current host server there ;see attached file

 there are two nodes;


 Cluster Name: SQL12CLU
 Current Host name: SQL12CLUB

 but when I look at the Roles in Failover Cluster management, SQL12CLUA seems to be owner node so why are they different? I think, the server in the Owner Role should be Active node,which is SQL12CLUA but on the other hand, I see the SQL12CLUB as a Current host name.. so is there any way about how to find the active node in FCM?
Avatar of Benjamin Voglar
Benjamin Voglar
Flag of Slovenia image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Teoman Sahin
Teoman Sahin


many thanks Benjamin so just out of curiosity  I would like to ask you something about this so what is the impact of the server in the Current Host server SQL12CLUB when I click the Cluster Name under Failover Cluster Manager..what things are hosted on the SQL12CLUB? yes you are right there is a role named ISQLAPPAG1 and this role is hosted on SQL12CLUA..there was nothing in Windows 2008R2 clustering I think? I only wondered

as you said, SQL12CLUA is active node and SQL12CLUB is passive node...
If something go wrong with SQL12LUA, server SQL12CLUB will automatically take ownership of your role. That meen he will be the owner of the ROLE and CLUSTER DISKS.

If you have to restart NODE A, you have to move the role first. Right click on the role and then select MOVE - SELECT NODE (OR BEST POSIBLE NODE).