April 11, 2014 at 11:23 pm
Windows 2008 cluster and windows 2008 r2 cluster
SQL 2008
For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive etc
and how to find if it is a server reboot or cluster failover
Summarizing..
1.Find cluster configuration .A/P or A/A or A/A/P etc
2.Is it server reboot or Cluster failover from one node to another or node restarted in same node
April 14, 2014 at 8:15 am
Nobody ever came across this info? 🙁
April 14, 2014 at 9:42 am
balasach82 (4/11/2014)
Windows 2008 cluster and windows 2008 r2 clusterSQL 2008
For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive etc
and how to find if it is a server reboot or cluster failover
Summarizing..
1.Find cluster configuration .A/P or A/A or A/A/P etc
2.Is it server reboot or Cluster failover from one node to another or node restarted in same node
1. There is no direct way to do this.
2. You need read the log file to distinguish it. Use xp_ReadErrorLog.
--
SQLBuddy
April 14, 2014 at 2:08 pm
balasach82 (4/11/2014)
Windows 2008 cluster and windows 2008 r2 clusterSQL 2008
For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive etc
and how to find if it is a server reboot or cluster failover
Summarizing..
1.Find cluster configuration .A/P or A/A or A/A/P etc
You can track the active node for an instance using SELECT SERVERPROPERTY('ComputernamePhysicalNetbios').
balasach82 (4/11/2014)
2.Is it server reboot or Cluster failover from one node to another or node restarted in same node
The easiest way to find out if a server reboot occurred, is to track the stopping and starting of the windows eventlog service through the windows system eventlog
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply