Tenant Media table id: 2000000184 growing exponentially

(1) Share

Report

Posted on by PhilJohnno

Our tenant media table is growing too large. It's currently 130 GB. We have retention polices set for emails, logs, etc. We have also run the Clean Up Tenant Media actions for Detached Media. Does anyone have any more input on actions we can take to clean this table safely? Any guidance is appreciated. thanks..

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (0)

Report

Hi

You must identify the origin of the documents, images or attachments that are causing this increase, based on that you may or may not delete their content. Or download them and save them on another external site.

Dynamics 365 Business Central: start thinking on storing Blobs outside of the database – Stefano Demiliani

Best

GR

Was this reply helpful? Yes No
PhilJohnno 29 on at

Like (1)

Report

GR. Thanks for the link. Although the link is more of a description of what I had put in my question/concern. While it describes the problem, it does not explain the HOW. I'm looking for the HOW to go about the resolution. If you have more information related to how to go about identifying and cleaning up, I would appreciate it. thanks..

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (2)

Report

Similar questions here:

Solved: Tenant Media table data arrangement

Tenant Media Table

Release tenant media table space.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

Another consideration is to export existing data, save it locally or on a server, and clear the exported data from the code.

Hope this can give you some hints as well.

Thanks.

ZHU

Was this reply helpful? Yes No