SQL Cluster Failover Notifications

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msadexchman - 25 Jan 2006 18:17 GMT

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

Reply to this Message

Anthony Thomas - 26 Jan 2006 03:12 GMT

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

> Hello,
>
[quoted text clipped - 6 lines]
>
> Regards

Reply to this Message

Linchi Shea - 28 Jan 2006 06:01 GMT

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

> Hello,
>
[quoted text clipped - 6 lines]
>
> Regards

Reply to this Message