Configuring email in Active-Active SQL server Failover clustering to send email when node switches

• keshab.basnet

  Ten Centuries

  Points: 1299

  More actions

  June 10, 2015 at 8:49 pm

  #297605

  Could you please suggest me that how to configure email in SQL server failover clustering. I need to configure email to send when node switches from one node to another. Can you please suggest me best way to configure email in fail over clustering?

• Maddave

  SSCertifiable

  Points: 6828

  More actions

  June 11, 2015 at 2:11 am

  #1804607

  I'm sure there are other ways, but you could execute a procedure on startup (information here https://msdn.microsoft.com/en-us/library/ms181720.aspx or http://zarez.net/?p=1566 ) which ran the code SELECT HOST_NAME() and emailed the result. This would show which node the instance is currently running on.