Auto Scheduled Backup entire Business Central SaaS Database Daily

(0) Share

Report

Posted on by MahGah

15,529

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

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

NicholasJackson16 80 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

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?)

Was this reply helpful? Yes No
Verified answer

DAnny3211 11,397 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

NicholasJackson16 80 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

Hi, just adding some info.

I have briefly tested the admin apis before, and I hope the following information can give you some hints.

https://yzhums.com/15755/

https://yzhums.com/12259/

Thanks.

ZHU

Was this reply helpful? Yes No