This article applies to:
- Trustwave MailMarshal (SEG)
- Trustwave ECM/MailMarshal Exchange 7.X
- WebMarshal
- SQL Express
Question:
- How do I adjust the retention period for MailMarshal and WebMarshal database logging?
Information:
MailMarshal and WebMarshal can log information to a SQL database for reporting purposes.
MailMarshal requires the database for configuration.
By default all versions of these products are configured to retain logging information in the SQL database for 100 days.
When you log a large amount of data, you could reach the database size limit for the free versions of SQL server:
- SQL Express 2008 R2 and above: 10 GB per database
- SQL Express 2005 or 2008: 4 GB per database
If the database reaches these limits the products will be affected as follows:
Trustwave MailMarshal (SEG); Trustwave ECM/MailMarshal Exchange 7.X
- Mail history as shown in the Console will not be up to date. Database log files will be stored on the node and not written to the database until existing information is deleted (for instance, the retention period for earlier messages or records expires).
- Mail processing will continue as per the configured policy. Users will be unaffected. However, you may be unable to save changes to configuration. If the disk on the procesing server(s) is full due to the database log files, processing will stop.
WebMarshal 6.X or 7.X
- WebMarshal browsing history and report logging will not be up to date, and the database log files logs will be stored on the nodes.
- WebMarshal users can continue to browse through WebMarshal as per the configured policy. However, if the disk on the processing server(s) is full due to the database log files, processing will stop.
- Processing does not require use of a database.
Procedure:
The simplest way to restore functionality is to reduce the logging retention period.
If you require logging data for extended periods, then you must upgrade to a full version of SQL Server. The full versions do not limit database size.
To change the log file retention period for the different versions of each Marshal product, follow the instructions below:
Trustwave MailMarshal (SEG); Trustwave ECM/MailMarshal Exchange 7.X
- In the MailMarshal Configurator or Management Console, navigate to Array Properties | Reporting.
- Change the Retain historic reporting data for field to an amount that is suitable for your reporting.
- Save changes and commit configuration.
Note: Database size is also affected by archiving and quarantine retention, because at least one message record is retained for each message in a folder. You can also reduce database size by changing the retention times for folders.
WebMarshal 6.X or 7.X
- In the WebMarshal console click on Tools and select Server and Array Properties.
- Select Database Logging from the left pane and change the Retain Logging data for field to an amount that is suitable for your reporting.
Note: WebMarshal 6.X or 7.X does not require database logging to function. Database logging can be turned off by unchecking the Enable database logging field.