Log Shipping Alerting

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Log Shipping Alerting

Log Shipping Alerting

Rate Topic

Display Mode

Topic Options

Author

Message

Chris D.

Posted Sunday, November 04, 2012 6:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, December 02, 2012 12:23 PM
Points: 1, Visits: 96

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!

Post #1380788

deepkt

Posted Monday, November 05, 2012 8:16 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:42 AM
Points: 202, Visits: 286

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.

Post #1381102

« Prev Topic | Next Topic »

Permissions