How to Manually configure Data aging with SQL Express and the Lotus Notes Report Pack. (4271765)

The following example will retain 365 days worth of data in the MessageStats database.
Changing the StatsRetentionDays value specifies the number of days to keep when the PR_LN_DataAgingDelStats stored procedure runs.

Open SQL Management Studio
Expand Databases | MessageStats | Table and Right click on the dbo.T_LN_Configuration table and select Open Table or Edit Top 200 Rows
Change the StatsRetentionDays to 365 and press enter. And close out the Tab
Open a new Query Window.
Switch to the MessageStats Database
Type the following Query
EXEC PR_LN_DataAgingDelStats
Click the Execute button