SQL Server Performance

Failover

Discussion in 'SQL Server 2005 Clustering' started by Rabani, Oct 21, 2008.

  1. Rabani New Member

    Hi,
    Can somebody please, let me know that how do we know exactly that a server has failed over to the secondary node. Also what does that effect the primary. Actually I am quite new in working in the clustered envirnoment.
    Thanks a lot
  2. Saurabh Srivastava New Member

  3. Elisabeth Redei New Member

    Hi,
    I guess it depends on how automated you want this to be but there should be messages in the eventlog indicating that the SQL Server service was shutdown on one of the nodes and another that it was started on the other node.
    Another way would be to start Cluster Administrator and look which node it is running, yet another to query the registry directly.
    HTH!
    /Elisabeth

Share This Page