I have a basic SQL Server 2008 log shipping setup with a Primary Server alert and a Secondary Server alert to send emails to a distribution group. On the Secondary server any time an alert is fired it sends out an email for the event as well as one for every single event/alert going back to when the server was first built (thousands of messages). Is there a queue, log, or table that I can clear these old entries from? Is it as simple as clearing the application log on the server itself?
Any guidance is appreciated!