Hey folks,

does anyone know any tool can detect a Failover of a SQL Cluster?

can either Spot light or SQL diagnostic manager detect Cluster failover?

thanks.

Thanks Ole for sharing your experience.

I am surprise to know there isn't much info logged on fail over...

A SQL Server job can sense failover, in a way. Actually, it can sense when
the SQL Server Agent starts up. And in failover, the agent starts on the
secondary node. See this article for details, including how to make SQL
Server notify you via e-mail when agent starts up. I used the info in the
article on a SQL 2008 cluster and it works.

http://www.mssqltips.com/tip.asp?tip=1663