Hello,

We have a 2 node active/passive SQL 2005 cluster and were wondering if
anyone knows if there is a solution which would allow someone to be notified
automatically should the active node failover to the passive node? Maybe an
email being sent? A page?

Any ideas?

Regards

Create a startup job in SQL Agent to page out a notification on SQL Agent
startup. This will notify you of failover or just a restart on the same
node. Either way, you will know that the system was offline momentarily.

I choose the SQL Agent over a startup proc because the boot sequence. Both
wait on the RECOVERY COMPLETE signal, but startup procs have to wait for the
xpstar.dll to load first, Agent comes online first.


Anthony Thomas


--

[quoted text, click to view]

You can write a script (VBScript or Perl) using Cluster Automation Server to
record the status and the current position of the instances, and compare the
info with the previous snapshot to determine whether anything has changed. I
do this to notify whether an instance is running on the preferred node(s).

Linchi

[quoted text, click to view]