Good morning,
We recently went under a Business Central update, and it was brought to our attention that we had an issue with capacity, so we deleted one of our sandboxes as we had to be able to do this update.
In further discussions, the main table that is taking space is the "Tenant Media" table (which stores our attachments). Our company has alot of files (excel, emails, pdfs) that get attached to sales orders, sales invoices etc. In addition, we added an extension app called "DocXTender" which we absolutely love for the ease of being able to drag and drop the files.
One of the suggestions we received were to drop the files on a SharePoint moving forward (not within the environment itself) which seems not productive at all as we review these attachments a lot and even go back to them after an order has shipped.
The question I have is, as our production environment continues to grow, we would like to know how companies have managed this issue and if they have any best practices.
We appreciate any insight/feedback you can provide.
Thank you!
Brittany Boyer