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;
SQL12CLUA
SQL12CLUB
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? Cluster1.jpg Cluster2.jpg
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).
as you said, SQL12CLUA is active node and SQL12CLUB is passive node...