recover quarantined messages |
Post Reply 
|
| Author | |
Derk 
Groupie 
Joined: 26 January 2005 Location: United States Status: Offline Points: 39 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: recover quarantined messagesPosted: 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?
|
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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... |
|
|
|
|
Derk
Groupie
Joined: 26 January 2005 Location: United States Status: Offline Points: 39 |
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
Derk
Groupie
Joined: 26 January 2005 Location: United States Status: Offline Points: 39 |
Post Options
Thanks(0)
Quote Reply
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.?
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
Derk
Groupie
Joined: 26 January 2005 Location: United States Status: Offline Points: 39 |
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.176 seconds.