Fail over notification

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.
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/
"jayjay" <jayjay@.discussions.microsoft.com> wrote in message
news:C157D178-1F88-4B69-9CF3-2C06E121C4DC@.microsoft.com...
>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.
|||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
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eJZ10rTBGHA.2912@.tk2msftngp13.phx.gbl...
> 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/
> "jayjay" <jayjay@.discussions.microsoft.com> wrote in message
> news:C157D178-1F88-4B69-9CF3-2C06E121C4DC@.microsoft.com...
>
|||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.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"jayjay" <jayjay@.discussions.microsoft.com> wrote in message
news:C157D178-1F88-4B69-9CF3-2C06E121C4DC@.microsoft.com...
>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.
|||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
"jayjay" <jayjay@.discussions.microsoft.com> wrote in message
news:C157D178-1F88-4B69-9CF3-2C06E121C4DC@.microsoft.com...
> 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.
|||Thanks Rodney,
"Rodney R. Fournier [MVP]" wrote:

> 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
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:eJZ10rTBGHA.2912@.tk2msftngp13.phx.gbl...
>
>
|||Thanks Mike,
"Mike Epprecht (SQL MVP)" wrote:

> 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/
> "jayjay" <jayjay@.discussions.microsoft.com> wrote in message
> news:C157D178-1F88-4B69-9CF3-2C06E121C4DC@.microsoft.com...
>
>
|||Thanks John,
"John Toner [MVP]" wrote:

> 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
>
> "jayjay" <jayjay@.discussions.microsoft.com> wrote in message
> news:C157D178-1F88-4B69-9CF3-2C06E121C4DC@.microsoft.com...
>
>
|||thanks Geoff,
"Geoff N. Hiten" wrote:

> 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.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "jayjay" <jayjay@.discussions.microsoft.com> wrote in message
> news:C157D178-1F88-4B69-9CF3-2C06E121C4DC@.microsoft.com...
>
>
|||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

"jayjay" <jayjay@.discussions.microsoft.com> wrote in message
news:C157D178-1F88-4B69-9CF3-2C06E121C4DC@.microsoft.com...
> 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.