Yesterday on of our databases starting giving an error during backups, and only backups, that I haven’t seen before:
Msg 3233, Level 17, State 1, Line 1 DUMP DATABASE for database 'master' failed: an alarm function could not be installed.
This error only occurs during backups. As usual, the documents I’ve located give general descriptions of the cause but only a typical “not enough, add more” solution. Nice, except I’d like to know what caused it in the first place so I can make sure it does not happen again. So if anyone knows how to locate the process taking up all the alarms or how to clear them without restarting the server please drop me a line.