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

check this out http://sql-server-performance.com/Community/forums/t/28428.aspx

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