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 undefined
Last Comment
Benjamin Voglar

8/22/2022 - Mon
Benjamin Voglar

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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...
Benjamin Voglar

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).
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes