How to manually purge data from your database
My database is getting very large and I would like to delete old records I do no longer need. How can I do that?
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.