Cluster alerts Neil Paddock 10.07.2007 15:42:00 Hi, How can I setup alerts to tell me when a cluster has failed over? The cluster is running SQL 2005 - can it be done through SQL Agent Alerts? Thanks, Neil Paddock.

Re: Cluster alerts "John Toner [MVP]" <jtoner[ at ]DIE.SPAM.DIE.mvps.org> 10.07.2007 17:19:14 Here's one way: http://support.microsoft.com/kb/260527 Regards, John Visit my blog: http://msmvps.com/blogs/jtoner "Neil Paddock" <NeilPaddock[ at ]discussions.microsoft.com> wrote in message news:7E42E8AF-0AC5-4967-9937-08F081DABD00[ at ]microsoft.com... [Quoted Text] > Hi, > > How can I setup alerts to tell me when a cluster has failed over? The > cluster is running SQL 2005 - can it be done through SQL Agent Alerts? > > Thanks, > Neil Paddock.

Re: Cluster alerts "Rodney R. Fournier [MVP]" <rod[ at ]die.spam.die.nw-america.com> 10.07.2007 17:20:39 What monitoring software are you using? That should do the trick nicely and tell you a lot more about the nodes :) You can also check out http://support.microsoft.com:80/kb/260527/en-us. It still applies to 2003 clustering. Cheers, Rodney R. Fournier MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://msmvps.com/clustering - Blog http://www.clusterhelp.com - Cluster Training ClusterHelp.com is a Microsoft Certified Gold Partner "Neil Paddock" <NeilPaddock[ at ]discussions.microsoft.com> wrote in message news:7E42E8AF-0AC5-4967-9937-08F081DABD00[ at ]microsoft.com... [Quoted Text] > Hi, > > How can I setup alerts to tell me when a cluster has failed over? The > cluster is running SQL 2005 - can it be done through SQL Agent Alerts? > > Thanks, > Neil Paddock.

Re: Cluster alerts "Ryan Sokolowski [MVP]" <ryan[ at ]clustering101.com> 10.07.2007 18:07:27 I'd recommend using MOM and the Cluster management pack...if that's possible in your situation. -- Ryan Sokolowski MVP - Windows Server - Clustering MCSE, CCNA, CCDA, BCFP This posting is provided "AS IS" with no warranties, and confers no rights. "Neil Paddock" <NeilPaddock[ at ]discussions.microsoft.com> wrote in message news:7E42E8AF-0AC5-4967-9937-08F081DABD00[ at ]microsoft.com... [Quoted Text] > Hi, > > How can I setup alerts to tell me when a cluster has failed over? The > cluster is running SQL 2005 - can it be done through SQL Agent Alerts? > > Thanks, > Neil Paddock.

Re: Cluster alerts Neil Paddock 11.07.2007 10:54:01 Thanks for your replys - I have followed your advice and followed the instructions from Microsoft. I cannot however use Net Send as the messenger service is disabled. I have however modified it to send an email using a command line emailer called Postie. However, this is not free for commercial use and was wondering could I use SQL/Database mail via SQLCMD to send an email from a batch file? I look forward to your response, Neil. "John Toner [MVP]" wrote: [Quoted Text] > Here's one way: > > http://support.microsoft.com/kb/260527 > > Regards, > John > > Visit my blog: http://msmvps.com/blogs/jtoner > > "Neil Paddock" <NeilPaddock[ at ]discussions.microsoft.com> wrote in message > news:7E42E8AF-0AC5-4967-9937-08F081DABD00[ at ]microsoft.com... > > Hi, > > > > How can I setup alerts to tell me when a cluster has failed over? The > > cluster is running SQL 2005 - can it be done through SQL Agent Alerts? > > > > Thanks, > > Neil Paddock. > > >

Re: Cluster alerts "Edwin vMierlo [MVP]" <EdwinvMierlo[ at ]discussions.microsoft.com> 11.07.2007 12:05:09 "Neil Paddock" <NeilPaddock[ at ]discussions.microsoft.com> wrote in message news:7D74AC16-FBE6-412F-87B4-B9B003A2249F[ at ]microsoft.com... [Quoted Text] > Thanks for your replys - I have followed your advice and followed the > instructions from Microsoft. I cannot however use Net Send as the messenger > service is disabled. I have however modified it to send an email using a > command line emailer called Postie. However, this is not free for commercial > use and was wondering could I use SQL/Database mail via SQLCMD to send an > email from a batch file? Neil, as long as you can script it you can use it, personally I use Blat.exe for email sending from small cmd scripts. Saying that, for a production cluster I would seriously recommend a good monitoring package, like Rodney and Ryan have recommended. Use a batch script for the interim, but start looking for a real monitoring solution Rgds, Edwin. > > I look forward to your response, > Neil. > > "John Toner [MVP]" wrote: > > > Here's one way: > > > > http://support.microsoft.com/kb/260527 > > > > Regards, > > John > > > > Visit my blog: http://msmvps.com/blogs/jtoner > > > > "Neil Paddock" <NeilPaddock[ at ]discussions.microsoft.com> wrote in message > > news:7E42E8AF-0AC5-4967-9937-08F081DABD00[ at ]microsoft.com... > > > Hi, > > > > > > How can I setup alerts to tell me when a cluster has failed over? The > > > cluster is running SQL 2005 - can it be done through SQL Agent Alerts? > > > > > > Thanks, > > > Neil Paddock. > > > > > >

Re: Cluster alerts "Russ Kaufmann [MVP]" <russ[ at ]clusterhelp.com> 11.07.2007 15:56:40 "Neil Paddock" <NeilPaddock[ at ]discussions.microsoft.com> wrote in message news:7D74AC16-FBE6-412F-87B4-B9B003A2249F[ at ]microsoft.com... [Quoted Text] > Thanks for your replys - I have followed your advice and followed the > instructions from Microsoft. I cannot however use Net Send as the > messenger > service is disabled. I have however modified it to send an email using a > command line emailer called Postie. However, this is not free for > commercial > use and was wondering could I use SQL/Database mail via SQLCMD to send an > email from a batch file? Mapisend.exe will work. Also, you can use blat. -- Russ Kaufmann MVP - Windows Server - Clustering ClusterHelp.com, a Microsoft Certified Gold Partner Web http://www.clusterhelp.com Blog http://msmvps.com/clusterhelp The next ClusterHelp classes are: July 10-13 in Denver July 16-19 in New York Sep 3 - 6 in Copenhagen