Small and medium business | Business Central, N...

Clean Tenant Media

(2) Share

Report

Posted on by Vicente Pastor

Hi guys,

I need help, I have a storage problem in my central Business Central environment.

Analyzing the stored data, I have seen that we have the “Tenant Media” table oversized and I want to empty it completely.

I have tried using data administration and searching for orphaned files, but it does not find any more orphaned files.

I have also tried to delete the data by code, inserting a button in a page and it works but for a few days, after a few days Microsoft blocks this action and recovers the deleted data.

I need your help, thank you very much

Regards

Vicente

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Jeffrey Bulanadi 8,431 on at

Like (0)

Report
Clean Tenant Media

Hi Vicente,

This behavior is by design—the Tenant Media table in Business Central stores media like images, documents, and binary data, with protective measures from Microsoft to prevent accidental deletion.

To address this issue, instead of fully clearing the table, consider:

Identifying and removing unused/unnecessary records.

Following Microsoft’s best practices for media management.

Implementing cleanup procedures within customizations.

Using retention policies where applicable.

For images specifically:

Compress them before storage.

Set size limits for uploads.

Company logo images are automatically maintained—avoid manual deletions as they’ll be restored.

If emptying the table completely isn't possible, consider alternatives:

Setting up retention policies.

Using proper cleanup methods in your code.

Leveraging external storage (Azure Blobs, containers, OneDrive) for seamless integration with Business Central.

Hope this helps! If you find this useful, feel free to mark it as a verified answer.

Cheers,
Jeffrey

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 19,137 Super User 2025 Season 2 on at

Like (1)

Report

Clean Tenant Media

Adding more details: https://learn.microsoft.com/en-us/dynamics365/business-central/application/system-application/codeunit/system.dataadministration.media-cleanup

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (0)

Report

Clean Tenant Media

There is no way to stop what has already happened.
You can communicate with the customer, for example, use AL Code to delete all Tenant Media and Change Logs created 3 years ago, to see if they can accept it.
Tenant Media can be downloaded using the following method, and Change Log can also be exported to Excel first.

Dynamics 365 Business Central: How to export all Media Contents (bmp, jpg,mp4…) from table 2000000184 “Tenant Media”

https://yzhums.com/26326/

For new customers: https://www.linkedin.com/posts/yzhums_dynamics365-dynamics-msdyn365-activity-7331131949798825986-FwC7?utm_source=share&utm_medium=member_desktop&rcm=ACoAABrxul8BUTv9mp6ntr62O4-TROdxRN6Wz4o

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 23,574 Most Valuable Professional on at

Like (1)

Report

Clean Tenant Media

Hi, good day
I hope this can help you, and give you some hints.

Solved: Tenant Media

Solved: Tenant Media table id: 2000000184 growing exponentially

Best Regards
Gerardo

Was this reply helpful? Yes No
Peter76 2 on at

Like (0)

Report

Clean Tenant Media

Hi Vincente,

I think you have to clear the media fields which point to the tenant media.

For instance:

Look at table 1173 Document Attachments

Clear the "Document Reference ID"

Was this reply helpful? Yes No
Vicente Pastor 31 on at

Like (0)

Report

Clean Tenant Media

Hi Zhu,

Yeah, I know, that's why they now work with sharepoint. The problem is that this has been done years ago and I need to free up space, can you think of what to do?

Regards

Vicente

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (0)

Report

Clean Tenant Media

1.4TB over? Because your Tenant Media is in use, if you clear it, it will affect the data.

If the company needs to manage a lot of attachments, it is recommended to use an external solution, such as the following.

Dynamics 365 Business Central: Manage attachments in SharePoint (Save attachments externally and do not use BC capacity)

https://yzhums.com/60356/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Vicente Pastor 31 on at

Like (0)

Report

Clean Tenant Media

Yes Rock, i try... but in the retention policies I cannot directly configure the table “Tenant Media”.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,291 Super User 2025 Season 2 on at

Like (0)

Report

Clean Tenant Media

Retention policy is a very nice feature which you can implement moving forward to auto clean the data.

Currently Data Administration and then deletion is the best standard approach. Did you try executing this?

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No
Vicente Pastor 31 on at

Like (0)

Report

Clean Tenant Media

I need to empty this table completely, I don't care if I lose the content.

Was this reply helpful? Yes No