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

All responses (4)

Answers (1)

Suggested answer

YUN ZHU 74,148 Super User 2024 Season 2 on at

Like (1)

Report

Tenant Media table id: 2000000184 growing exponentially

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
Verified answer

Valentin Castravet 24,961 Super User 2024 Season 2 on at

Like (2)

Report

Tenant Media table id: 2000000184 growing exponentially

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/
PhilJohnno 49 on at

Like (1)

Report

Tenant Media table id: 2000000184 growing exponentially

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..
Suggested answer

gdrenteria 12,546 Most Valuable Professional on at

Like (0)

Report

Tenant Media table id: 2000000184 growing exponentially

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