I'm interested in hearing about your experiences with offloading historical fiscal years from Business Central to an external database in order to keep the production database size under control. I'm currently working with a customer whose Business Central database is growing by almost 1 GB per day. We've already reviewed the standard cleanup options (retention policies, log cleanup, removing obsolete data, etc.), but unfortunately these have only a limited impact on the overall database growth.
We're now exploring whether archiving or offloading closed fiscal years to an external database could be a viable long-term solution.