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.

See also:

How to reduce the size of your SQL database

14 Jan 2021

Configuration

About the author

Promodag

Our flagship reporting tool, Promodag Reports, is an innovative and constantly improving email reporting product that brings together all the key elements from Office 365, hybrid and on-premise Exchange messaging environments.