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;
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
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
Powershell
Last Comment
Benjamin Voglar
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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.
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).
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...