Fail over notification

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jayjay - 20 Dec 2005 01:45 GMT

I have Sql 2000 on Windows 2003 server, i would like to be notified when
cluster fail over accours. How can i do this.

Your help is greatly appreciated.

Reply to this Message

Mike Epprecht (SQL MVP) - 20 Dec 2005 07:56 GMT

Hi

Monitoring Software like Tivoli, HP Openview etc.

Else, write an application that plugs into WMI and work it from there.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

>I have Sql 2000 on Windows 2003 server, i would like to be notified when
> cluster fail over accours. How can i do this.
>
> Your help is greatly appreciated.

Reply to this Message

Rodney R. Fournier [MVP] - 20 Dec 2005 13:52 GMT

MOM 2005 and NetIQ's AppManager work very well :)

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training

> Hi
>
[quoted text clipped - 17 lines]
>>
>> Your help is greatly appreciated.

Reply to this Message

jayjay - 20 Dec 2005 20:11 GMT

Thanks Rodney,

> MOM 2005 and NetIQ's AppManager work very well :)
>
[quoted text clipped - 28 lines]
> >>
> >> Your help is greatly appreciated.

Reply to this Message

jayjay - 20 Dec 2005 20:11 GMT

Thanks Mike,

> Hi
>
[quoted text clipped - 17 lines]
> >
> > Your help is greatly appreciated.

Reply to this Message

Geoff N. Hiten - 20 Dec 2005 15:08 GMT

One simple way is to have your SQL server run a startup stored procedure
that emails a message like "SQL Cluster Server Fubar has just restarted at
hh:mm". You can then ignore or supress the message for planned maintenance
windows.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>I have Sql 2000 on Windows 2003 server, i would like to be notified when
> cluster fail over accours. How can i do this.
>
> Your help is greatly appreciated.

Reply to this Message

jayjay - 20 Dec 2005 20:12 GMT

thanks Geoff,

> One simple way is to have your SQL server run a startup stored procedure
> that emails a message like "SQL Cluster Server Fubar has just restarted at
[quoted text clipped - 5 lines]
> >
> > Your help is greatly appreciated.

Reply to this Message

John Toner [MVP] - 20 Dec 2005 18:19 GMT

Another way to accomplish this would be to have a generic script/application
cluster resource in your cluster groups that launch a file that will trigger
the notification. You can review the following KB article for an example:

http://support.microsoft.com/kb/260527

Regards,
John

> I have Sql 2000 on Windows 2003 server, i would like to be notified when
> cluster fail over accours. How can i do this.
>
> Your help is greatly appreciated.

Reply to this Message

jayjay - 20 Dec 2005 20:11 GMT

Thanks John,

> Another way to accomplish this would be to have a generic script/application
> cluster resource in your cluster groups that launch a file that will trigger
[quoted text clipped - 9 lines]
> >
> > Your help is greatly appreciated.

Reply to this Message

Anthony Thomas - 24 Dec 2005 14:49 GMT

In addition to a startup procedure, you could also create a SQLAgent startup
job that does the same thing. Keep in mind, however, that startup
procedures will have a different startup sequence than SQLAgent startup
jobs: the later will not initiate until the database recovery process is
complete; startup procedures are launched earlier in the boot-up sequence.

Sincerely,

Anthony Thomas

> I have Sql 2000 on Windows 2003 server, i would like to be notified when
> cluster fail over accours. How can i do this.
>
> Your help is greatly appreciated.

Reply to this Message