Post reply

SQL 2005 Clustering and Notifications

  • January 25, 2006 at 11:16 am

    #167273

    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

  • January 26, 2006 at 1:52 pm

    #617317

    There are plenty of network monitoring tools you could use...

    Here is TSQL I use to see what node is running. The first line of 'net statistics server' returns the node name. I then compare to what it should be, or to see if there is a change. When a change occurs, you could send email etc.

    create

    table #Output(rowid int identity (1,1),x varchar(8000))

    insert

    #Output exec xp_cmdshell 'net statistics server'

    select

    top 1 x from #Output order by rowid

    drop

    table #Output

    Terry

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply