Mirroring alerts

  • Hi,

    In one of our customers the database mirroring was already configured. After long years they came to us and asking to configure the database mirroring alerts. The alerts needs to come to their mailid if some things happens to the mirroring.

    In the server the database mail id is already configured for failure jobs.

    Now i need to configure same mailid for mirroring alerts also.

    I am completely lost in touch with mirroring after always on came into the market.

    Can anyone please help me to configure db mirroring alerts in the same server.

    what exactly i need to follow to set mail alerts for current mirroring setup.

    Thanks,

    Jo

    • This topic was modified 4 years, 3 months ago by  pols.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Depending the level of monitoring you want, you can setup some simple state monitoring for mirrors using the instructions here: https://www.mssqltips.com/sqlservertip/1859/monitoring-sql-server-database-mirroring-with-email-alerts/

    If you want more comprehensive monitoring of mirroring health and performance, check out the Microsoft Docs article here: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/use-warning-thresholds-and-alerts-on-mirroring-performance-metrics-sql-server?view=sql-server-ver15

     

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply