How do I change the number of days that emails are retained in the DeadLetter folders?

This article applies to:

• Trustwave MailMarshal (SEG) 6.8 and below
• Trustwave ECM/MailMarshal Exchange 7.X

Question:

Procedure:

Note: In Trustwave MailMarshal (SEG) 6.9 and above, you can use the MailMarshal Configurator or Management Console to change the retention for Dead Letter folders. For details see Help.

In versions 6.8 and below, this setting can be changed, but requires editing the SQL database directly.  Care must be taken when editing the SQL database directly since some changes could cause MailMarshal to stop functioning correctly.

Warning!  Changing the records in any database table is not supported unless directly instructed to do so by Trustwave Technical Support.

To change the setting:

1. Open the database using SQL Enterprise Manager. 
2. Open the Folder table (Open Table | Return All Rows).
3. Change the RetentionDays column on the Dead Letters, Malformed, Routing, Encryption, Undetermined, and Malformed Mime folders to your desired period (in days).
4. Restart the MailMarshal Array Manager Service.
5. Open the Configurator and make a rule change (i.e. disable and then re-enable a rule).  This sets a flag that indicates that there are changes to be replicated to the node(s).
6. Click Commit Configuration Changes to force the new retention settings to be replicated to the node(s).

This article was previously published as:

NETIQKB43284