Click here to Skip to main content
15,791,531 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I have configured the database mirroring,and would like configure same thing to alerts if some thing goes down in mirroring ,I need all the jobs related to mirroring which alert me through Mail.Could please provide me the step by step alerts configration or any scripts.. to get alerts..

1 solution

Hi Chetan,

We can configure alerts for database mirroring by many ways. Generally when mirroring fails like mirror server is down or principal server is down in opposite partner we will get 1474 error.

We can configure event alert for this error we can mention some operator name in alert response. But before this you have to configure Database Mail. You can check the following link to configure database mail.

Configuring Database Mail in SQL Server

We can configure WMI Alert also which sends the notification to required EMail ID.

Hope I have answered your question.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900