Home > IT Answers > DataCenter > Email notification in the event of a SQL Server database failover
SQL Server Ask the Experts
2,585 pts.
 Email notification in the event of a SQL Server database failover
Failover, SQL Server database
In case of a failover of a SQL Server database, I’d like to be notified by email. Can you tell me how to activate this option?

Software/Hardware used:
ASKED: September 2, 2008  7:04 PM
UPDATED: September 3, 2008  2:56 PM
RELATED QUESTIONS
Answer Wiki:
There is no option to have the cluster service inform you in the event of a fail over. You have a couple of options as far as monitoring for a fail over. 1. Setup your normal monitoring solution to monitor the event logs on the nodes of the cluster looking for the SQL Server service starting. 2. Setup a SQL Agent job to send an email when it runs, and have that job scheduled to run every time the SQL Agent starts.
Last Wiki Answer Submitted:  September 2, 2008  9:30 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.
 

Such a simple solution, and so easy to implement! Why didn’t I think of this?!? Thanks…

-robert

rllefebv
 25 pts.