Home > IT Answers > Database > Is there a way to set up database mirroring i...
Help

Question

  Asked: May 7 2008   4:12 PM GMT
  Asked by: SQL Server Ask the Experts

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: May 7 2008  6:23 PM GMT  by Mrdenny




You can setup a SQL Agent Alert for alertID 1480. Then create a job which the alert runs when it is triggered.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and SQL Server.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   May 7 2008  6:24PM GMT

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