Log Shipping Alerting

• Chris D.

  Grasshopper

  Points: 13

  More actions

  November 4, 2012 at 6:58 am

  #284149

  Hello -

  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!

• deepkt

  SSC Eights!

  Points: 951

  More actions

  November 5, 2012 at 8:16 am

  #1556068

  Hi,

  As per my understanding any mail is queued and processed through msdb -System database.

  You can clear the entries in the msdb, see below tables.

  SELECT * FROM sysmail_mailitems

  SELECT * FROM sysmail_log

  And you can delete the entries from above tables from msdb database.