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

Reducing Business Central Database Size by Retaining Recent Data Only

(1) Share

Report

Posted on by Nithyan G

Hello everyone,
I have a Business Central database with over 500 GB of data. I would like to retain only the last two years of data and delete the rest, without compressing the data.
Is there a way to achieve this?

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 73,698 Super User 2024 Season 2 on at

Like (1)

Report

Reducing Business Central Database Size by Retaining Recent Data Only

If the data of two years exceeds 500G, I wonder if there are some bad practise customizations, such as storing a lot of attachments or adding a lot of Blob fields?

The data size can be checked in the table mentioned by gdrenteria.

Then you can export the data through Configuration Package and clear the data through AL Code.

Hope this can give you some hints.

Thanks.

ZHU
gdrenteria 12,183 Most Valuable Professional on at

Like (1)

Report

Reducing Business Central Database Size by Retaining Recent Data Only

Hi

If you work a lot with attached documents, this also penalizes you. If you check the following option, see which tables are the "heaviest." You should definitely enable the option to save documents in another external location. Also, check if you use email sending with attached documents, this also penalizes you.

Best

GR
Suggested answer

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

Like (1)

Report

Reducing Business Central Database Size by Retaining Recent Data Only

You can look into deleting documents - Manage storage by deleting documents or compressing data - Business Central | Microsoft Learn

You can also look into retention policies - Clean Up Data with Retention Policies - Business Central | Microsoft Learn

Also, do you know which tables are taking the majority of space? 500gb is a lot for a Business Central database. If you don't know, you can look at the Table Information Page to see which tables are taking up a lot of space. Usually its things like attachments or change log entries. I prefer to delete these before deleting actual documents.

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

Reducing Business Central Database Size by Retaining Recent Data Only

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Leaderboard

Featured topics

Product updates

Reducing Business Central Database Size by Retaining Recent Data Only

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates