How to manually purge data from your database

Question:

My database is getting very large and I would like to delete old records I do no longer need. How can I do that?

Answer:

Use the Purge Message Tracking Data, Purge IIS Data and Purge Storage Size Data options, that you will find in the Tools menu.

You simply need to

Select the Exchange servers that generated the records you would like to purge,
"Push" them to the right pane,
Set the start and end dates of the purge,
Click OK to start the process. It can take some time depending on the quantity of data to purge.

Traffic events imported from message tracking files, and events imported from IIS log files generally take the most space.

We recommend to purge periods not exceeding 2 weeks at the beginning, and to compact the database between each period. Purging larger period can increase the SQL database transaction log size drastically.

Related article: How to reduce the size of your SQL database

Try Promodag Reports Free for 45 Days

Start your free trial