You’re offline. This is a read only version of the page.
Announcements
Hi
I know we can go to Business Central Admin Center then "create database export " but this has limitation (I think 8 times per month). Also, we cannot automate this process (auto scheduled). Also, I know Microsoft provides 28 days restore point. But we need to keep our backup longer than that.
What is the best method to backup entire Business Central SaaS database daily on auto schedule?
Thanks
Outside of exporting a copy of the database using the admin tool (which you mentioned the limitations of), you're required to use the API. However, the API's biggest limitation is bandwidth (only about 2 MB/sec, up to 5 parallel calls). Also, a very limited number of tables are natively exposed via API, meaning you will have to generate new API endpoints.
My suggestion would be to setup a delta-load process using something like Azure Data Factory or Azure Synapse, load it to either a database or Azure Data Lake, and take a daily snapshot of the data from there.
Getting full database backups every day is not feasible with the current limitations. I'd ask your management team what they really care about and why. Is it for reporting? Restoring data? What data? For how long? How much data? etc.
Do you truly need a full database backup, or can you use a more efficient delta load?
Kennie published some good ideas here about how to get data out of BC SaaS in bulk: github.com/.../ExtractData
Hi
the backup directives are as you listed and it is not schedulable, only the monthly backups are 10 and not 8.
the best way would be to schedule a backup at the end of the 28 days and the day before microsoft's version upgrade of BC.
BC also now exposes APIs for the admin centre, so you could develop a flow that under process queue could do this
some info from my blog
danieleincalza.blogspot.com/.../business-central-export-database-saas.html
check my answer if it helped you, thanks
DAniele
#1
André Arnaud de Cal...
293,781
Super User 2025 Season 1
#2
Martin Dráb
232,749
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
