We are trying to find a solution on how we can reduce the data in ActivtyPointerBase. Purging all unnecessary email/activity had been done but did not do much in our overall Database Capacity.
Maybe someone can help or explain on how to fix it. Thank you!
This article is used as guidance: [Customer Guide] How to Reduce ActivityPointerBase - Dynamics 365 General Forum Community Forum
Have you run the reports in the article to identify which activities are using most space and confirmed that it is email?
I have encountered this in the past where a mailbox was configured to sync everything server side and the user frequently sent or received emails with excel/word documents attached.
The solution was to use migrate those emails to SharePoint or Azure blob storage.
There are a number of third party solutions to do just that, such as:
Hi,
The typical culprit of ActivityPointer bloat is the Description column. For Email activities in particular, the email body is stored in this column which can very quickly eat up storage at higher volumes
powerusers.microsoft.com/.../1532112
You can also raise support ticket with Microsoft for recommendations
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148