Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am looking for the actions one must take to cause Threshold Alerts to occur for a single mirrored database on an instance of SQL Server 2008 containing multiple mirrored databases.

FYI: This is already posted on and submitted as a bug on Microsoft Connect.

share|improve this question
up vote 5 down vote accepted

Joe Sack's answer on ServerFault is as good as it gets:

For some background, Joe runs the Microsoft Certified Master of SQL Server program. He knows his stuff. (I can vouch for him personally.)

share|improve this answer
Thank you Brent. I do hope that the Microsoft Connect team addresses this issue in a future update. – EngineeringSQL May 27 '11 at 18:13
Update from Microsoft "... the underlined issue was identified as a core Engine issue ... will not be classified as a hotfix required for the SQL 2008 or SQL 2008 R2. We will try to address this issue in our current release for SQL 2011 ... the risk for breaking existing functionality by changing the output format (the message format) is fairly high. We decided therefore that we cannot make this change ... workaround is to create your own alert that includes the complete message. See also"; – EngineeringSQL Aug 23 '11 at 16:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.