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
