Hi Amar,
Since you are using Dynamics 365 Business Central on Azure Cloud, Microsoft automatically manages backups, so there is no direct option to take a database backup on your local system. However, there are a few ways to export and store your data regularly.
Manual Data Export
One of the simplest methods is to manually export your data using Configuration Packages in Business Central. You can:
- Go to Configuration Packages (search for it in Business Central).
- Select the tables you want to back up (e.g., Customers, Vendors, Ledger Entries).
- Export the data as an Excel or XML file and save it on your local system.
Automated Data Export Using APIs
If you need regular automated backups, you can use Business Central APIs:
- Set up Power Automate or Logic Apps to extract data periodically.
- Save the data to OneDrive, SharePoint, or a local storage system.
- This method allows you to schedule weekly/monthly backups without manual effort.
Azure SQL Backup (For Admins)
If you have admin access to your Azure SQL database, you can:
- Use Azure SQL Export to download a database backup.
- Use Azure Data Factory or Synapse Analytics to extract and store data.
- Note that SaaS users don’t have direct database access, so this applies only to Managed Instances.
Third-Party Backup Tools
You can also use third-party tools like Jet Reports to extract data and store it locally. These tools can help automate the process and ensure regular backups.
Microsoft automatically backs up your Business Central data every 30 minutes, and these backups are retained for 28 days. If you need to restore a backup, you can contact Microsoft Support to request a data recovery. Direct access to the database is not available in the SaaS version, so local backup options are limited to data exports.
Let me know if you need more details!
Regards,
Dr. Gomathi S
