SQL 2005 Cluster

• HBK_4700

  SSCrazy Eights

  Points: 8932

  More actions

  September 15, 2010 at 10:32 am

  #157203

  Hi,

  Whether can I check whether our server is active/active or active/passive

  Appreciate your quick response. Thank you.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 15, 2010 at 10:51 am

  #1221528

  Just check whether each of your cluster nodes (Assuming that 2 node cluster) are running atleast one sql server instance.

  You can do this from Cluster administrator on any node.

  Suppose you have 2 nodes, Node A And Node B and 2 instances SQL 1 and SQL 2.

  If SQL 1 is Running on Node A and SQL2 is ruinning on Node B or vice versa, then the cluster is ACTIVE/ACTIVE.

  If both instances are running on one node and the other node is passively waiting for the failover and doing nothing then it is ACTIVE\PASSIVE.

  Thank You,

  Best Regards,

  SQLBuddy