15,428
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
Hi, just adding some info.
I have briefly tested the admin apis before, and I hope the following information can give you some hints.
Thanks.
ZHU
Thanks NicholasJackson16
You answer was really helpful. I know their answers which mainly because of bad experience with our old ERP system and not trusting on SaaS as well.
But at least I can show them these options and pros/cons of them.
Thanks
Hi DAnny3211
Awesome. Thanks. Where I can see that API for admin center.
Also, I am new to flow do you mean
1) I follow your article for app registration
2) Then create a Flow and call the API on schedule and that is it (up to 10 times a month)
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.
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
Thanks NicholasJackson16
Great article. Thanks for sharing.
Looks like our management team prefer full database backup. Is this even possible (I know in theory the answer always is yes but is it practical?)
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (