Skip to main content

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
  1. Select the Exchange servers that generated the records you would like to purge,
  2. "Push" them to the right pane,
  3. Set the start and end dates of the purge,
  4. 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. 

If you use a SQL database, 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:

 

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.

Try Promodag Reports Free for 45 Days

Cookie Notice

Find out more about how this website uses cookies to enhance your browsing experience.