SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Log Shipping Alerting


Log Shipping Alerting

Author
Message
Chris D.
Chris D.
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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!
deepkt
deepkt
Old Hand
Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)

Group: General Forum Members
Points: 333 Visits: 362
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search