Testing I have completed to date seems to indicate that the following Threshold Alerts need to be defined for the <all databases>
Database Name rather than a single named database:
- Unsent Log Threshold (Error Message 32042)
- Oldest Unsent Transaction Threshold (Error Message 32040)
- Unrestored Log Threshold (Error Message 32043)
- Mirror Commit Overhead Threshold (Error Message 32044)
This is in contrast to the documentation provided by Microsoft:
I have confirmed that Error Numbers 32040, 32042, 32043 and 32044 are being written to the SQL Server Log, as per sp_altermessage
:
/* Unsent Log Threshold (http://msdn.microsoft.com/en-us/library/aa337325.aspx) */
sp_altermessage 32042, 'WITH_LOG', TRUE
If you were successful, I would appreciate if you describe the actions you took to cause Threshold Alerts to occur for an individual database.
Thank you.