Home > IT Answers > Database > Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?
SQL Server Ask the Experts
2,585 pts.
 Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?
Database mirroring, SQL Server 2005, SQL Server alerts
I'm setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

Software/Hardware used:
ASKED: May 7, 2008  4:12 PM
UPDATED: May 7, 2008  6:24 PM
RELATED QUESTIONS
Answer Wiki:
You can setup a SQL Agent Alert for alertID 1480. Then create a job which the alert runs when it is triggered.
Last Wiki Answer Submitted:  May 7, 2008  6:23 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 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,550 pts.