Print Page | Close Window

recover quarantined messages

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5091
Printed Date: 26 December 2024 at 7:44pm


Topic: recover quarantined messages
Posted By: Derk
Subject: recover quarantined messages
Date Posted: 07 March 2005 at 3:14pm

if I go through the potential spam list, deliver a few messages and delete the rest what would the appropriate query be to display the deleted/quarantined messages?  I guess the scenario would be if I'm trying to recover a message I previously thought was spam?

 

 


Replies:
Posted By: LogSat
Date Posted: 07 March 2005 at 5:06pm
Derk,

When an email is force-delivered, it is then tagged to be deleted. SpamFilter will run a cleanup query that deletes all such "tagged" emails every hour (unless you changed this setting). Once they are deleted, the only way to recover lost data from a database is from a backup...


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: Derk
Date Posted: 08 March 2005 at 1:54pm
would there be any particular reason I couldn't make the cleanup query a few days rather than 60 minutes?  Would they be a significant performance decrease?

Posted By: LogSat
Date Posted: 08 March 2005 at 4:22pm
It would depend on your database server. Deleting records (emails) after days rather than hours will increase your database size.  Running a SQL command to erase 30 times the number of emails than you'd otherwise have if removing them hourly will demand much more CPU. If your DB server has disk space and CPU to spare, then it should not be a problem.

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: Derk
Date Posted: 27 April 2005 at 12:41pm

I have changed the expire interval to 2880 minutes (48 hours).  My question is does this schedule a purge every 48 hours or more frequently and purges messages that are over 48 hours old?

for example scenario #1: if the last purge was Monday at 4 p.m. I could feasibly recover a message up to Wednesday at 4 p.m.

scenario #2: continuing from scenario #1; on Thursday morning will I be able to recover a message from Tuesday or would it have been purged on Wednesday at 4 p.m.?

 

Posted By: LogSat
Date Posted: 27 April 2005 at 4:09pm
When SpamFilter is started a timer is also started. From then on, every NN minutes the purge procedure is invoked. NN is the value under "Enter the interval in minutes for when the expired emails are deleted from the quarantien database". In turn, when it runs, the purge procedure will delete any emails whose date is less than or equal to (Now - DD). Now is the time at which the purge is executed, DD is the value under "Enter the number of days to store quarantined rejected emails.

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: Derk
Date Posted: 27 April 2005 at 6:24pm
sounds like I need to create my own scheduled task to purge the old messages.  You don't happen to have handy the basic equivalent SQL query I could run to accomplish the task?

Posted By: LogSat
Date Posted: 27 April 2005 at 10:37pm
For flexibility we split it in two pieces:

UPDATE tblQuarantine SET Expire = 1 WHERE MsgDate <= :MsgDate:

DELETE tblMsgs FROM tblMsgs INNER JOIN tblQuarantine
    ON tblMsgs.MsgID = tblQuarantine.MsgID
    WHERE tblQuarantine.Expire <> 0

SpamFilter has a more complex query to take in consideration the existance of multiple instances of SpamFilter storing data in the same database, but the above should be fine when run from the SQL server itself.


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Print Page | Close Window