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:
Answer:
To determine the dates of the oldest records, start by opening the File > Database Properties window.
Then use the Tools > Purge Message Tracking Data, Purge IIS Data and Purge Storage Size Data options.
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
Comprehensive Exchange reporting made simple for Office 365, On-Premise, and Hybrid environments
Start your free 45-day trial of Promodag Reports