Database mirroring monitor job

  • Why does the database monitoring job indicate success when my database are disconnected after the certificate has expired?

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • Because the job suceeded. The mirroring monitor job does not raise alerts if there are issues. It simply checks the health of mirroring and logs it. I know this is contrary to the way the log shipping monitor works, but it was designed to raise alerts. You can configure alerts and notifications for mirroring issues, but the monitor won't do it automatically.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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