Tell me more ×
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. It's 100% free, no registration required.
up vote 5 down vote favorite

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 ServerFault.com and submitted as a bug on Microsoft Connect.

share|improve this question

1 Answer

up vote 3 down vote accepted

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

http://serverfault.com/questions/251551/sql-server-2008-mirroring-threshold-alerts-at-database-level/251989#251989

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. – echoScout May 27 '11 at 18:13
1  
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 technet.microsoft.com/en-us/library/cc966392.aspx"; – echoScout Aug 23 '11 at 16:58

Your Answer

 
discard

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.