Reduce Storage Usage for Business Central using Data Administration

Introduction

By default, Business Central comes with 80GB of storage capacity across three sandbox environments and 1 Production Environment with an additional 3GB/Premium License, 2GB/Essential License, 1GB/Device license.

These storage limits depending on your Business volume may run out if the data is not managed properly.

Business Central now comes with a one stop view where you can manage (compress or delete) the entries to reduce storage usage – “Data Administration.”

Pre-requisites

Business Central Cloud/On Prem

References

Manage Storage by Deleting Documents or Compressing Data – Business Central | Microsoft Learn

Configuration

In Business Central, we’ve had the option to view the capacity usage from the Admin Center for a while now.

Recently, they’ve also added a one stop view to check and manage the capacity usage – Data Administration from within Business Central itself.

It can be found directly from the global search.

The first time we open this we are greeted with an empty view, the data is loaded after we click on refresh to load the latest data.

You can also configure it so that the data is loaded automatically in the background every so often.

Here, we get the options for Data Clean up where we can delete data that isn’t required anymore.

All of the below options, open a similar processing report where you can set filters which are used to delete the records as needed.

The “Delete Detached Media” opens another page which I’ve discussed in depth in another blog.

The second action groups hold actions which are meant to compress the ledger entries which can drastically reduce the storage space used.

It is important to note that you can only compress entries which are older than 5 years by yourself which belong to Fiscal years that are closed and the entries themselves are closed (Open is set to false).

You can configure the compression such that there is one entry per day, one entry per week, one entry per month, one entry per quarter, one entry per year or one entry for the period that is defined for compression.

You also have the functionality to delete empty registers from here.

If these individual actions seem to be overwhelming, Microsoft also provides for a Data Administration wizard which simplifies this process and allows you to manage the capacity via a wizard.

Conclusion

Thus, we saw how we can use the standard data administration tools to manage capacity of Business Central environment which can help the system run much more efficiently in terms of both performance and costs.

We hope you found this article useful and if you would like to discuss anything you can reach out to us at [email protected].