Hi everybody,
I found this thread kind of late, but is only now that I've got the problem! I configured an alert on 18278 to net send a message when the transaction log is truncated for <mydb>. The alerts is active, the operator to be notified is OK (receives notifications from other alerts and the test is sending the message).
Then I issued:
backup log mydb with truncate_only
I was expecting to see the pop-up window sent when the alert was fired, but nothing happened. I can see in SS2K error log that the log for that database was truncated but the alert didn't fire (Count shows 0 in the EM).
Can anybody help with an explanation?
Thanks,
Gabriela