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

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (1)

Report
1. Use the Detached Media Cleanup Page

Navigate to Data Administration in Business Central.

Select More Options if needed.

Go to Actions > Data Cleanup > Miscellaneous > Delete Detached Media.

If you want to delete media without reviewing, select Actions > Schedule Cleanup Task and confirm deletion.

2. Use the Media Cleanup Codeunit

Business Central provides a Media Cleanup Codeunit that helps remove orphaned media entries.

You can use the GetDetachedTenantMedia method to identify detached media.

The GetTenantMediaFromDetachedMediaSet method can also help remove media linked to detached sets.

3. Delete Orphaned Media Using Built-in Methods

If you're using Business Central 2023 Wave 1 (BC22) or later, Microsoft introduced:

Media.FindOrphans() – Finds orphaned media.

MediaSet.FindOrphans() – Finds orphaned media sets.

You can use these methods to identify and delete unused media files

For Details: https://learn.microsoft.com/en-us/dynamics365/business-central/application/system-application/codeunit/system.dataadministration.media-cleanup

Mark below checkbox to make this answer Verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (1)

Report

you may want to consider implementing some sort of retention policy for the Tenant Media table, such as regularly purging old or unused records. This can help to keep the size of the table under control and prevent it from consuming excessive disk space. However, be sure to carefully consider any potential impact on your business processes before implementing such a policy.

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

Like (0)

Report

Hi Sohail,

Thank you very much for your quick response.

But the problem is that the files in the table "Tenant Media" are NOT orphaned. Then when I click on delete orphaned data it does not delete anything.

I still have the same problem after following your instructions.

Regards

Vicente

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

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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

Like (0)

Report

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

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
Peter76 2 on at

Like (0)

Report

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
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (1)

Report

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