更改数据库镜像 [英] Alters for Database mirroring

问题描述

我已经配置了数据库镜像，并且想配置相同的东西以在镜像发生故障时发出警报，我需要通过Mail提醒我的所有与镜像有关的作业.请提供逐步警报配置或任何脚本的信息..以获取警报..

Hi,

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..

推荐答案

您好，Chetan，

我们可以通过多种方式为数据库镜像配置警报.通常，当镜像失败(例如镜像服务器关闭或对方服务器的主服务器关闭)时，我们将收到1474错误.

我们可以为该错误配置事件警报，我们可以在警报响应中提及一些操作员名称.但是在此之前，您必须配置数据库邮件.您可以检查以下链接来配置数据库邮件.

在SQL Server中配置数据库邮件

我们还可以配置WMI Alert，该通知将通知发送到所需的电子邮件ID.

希望我已经回答了您的问题.

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.

这篇关于更改数据库镜像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！