Hello I have some request Detail I requested to backup database on cloud / azure Please may help guidance step exporting database into Please may help guide user permission which role can be export database into BACPAC file I try to do this one https://community.dynamics.com/blogs/post/?postid=587b05e3-f792-45e0-a5a7-5864cefd268f But still no have storage came to container

Hello database , Welcome to the Microsoft Q&A and thank you for posting your questions here. Regarding your questions, you should have the appropriate permissions such as sysadmin, securityadmin, db_owner and make sure the user also has access to the Azure Storage account and container where the BACPAC file will be stored. You can assign the Storage Blob Data Contributor role to the user for the specific storage account. If you are still facing issues with the storage container not appearing, ensure that: The storage account and container exist and are accessible. The user has the necessary permissions to access the storage account. You can find more detailed steps and considerations for exporting a database to a BACPAC file in this documentation - https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql I hope this is helpful! Do not hesitate to let me know if you have any other questions. Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.

The message typically means the process is ongoing. It can take some time depending on the database size. In the Azure portal, which will show updates on the export status. If the export does not show up in the container: Verify that there are no permission issues with the storage container or the database. Check if there are any network issues or timeouts causing the export to fail. If you're using an Automation Account to trigger the export, check the logs for any errors. Don't forget that you need to have the following permissions: Business Central Admin Role : You should have SysAdmin or BCAdmin role in Dynamics 365 Business Central. Azure Permissions : You need appropriate access to the Azure SQL Database resource (such as being a Contributor or Owner of the Azure SQL Database instance). Specifically, you need the permission to manage and export BACPAC files. https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export

Microsoft Business Central 365 : Backup Database on cloud / azure service

Accepted answer

Sina Salam 16,446 Reputation points

2025-01-18T19:36:15.9466667+00:00
Hello database,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Regarding your questions, you should have the appropriate permissions such as sysadmin, securityadmin, db_owner and make sure the user also has access to the Azure Storage account and container where the BACPAC file will be stored. You can assign the Storage Blob Data Contributor role to the user for the specific storage account.

If you are still facing issues with the storage container not appearing, ensure that:

The storage account and container exist and are accessible.

The user has the necessary permissions to access the storage account.

You can find more detailed steps and considerations for exporting a database to a BACPAC file in this documentation - https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.
Please sign in to rate this answer.
Sai Raghunadh M 1,915 Reputation points Microsoft Vendor

2025-01-20T09:37:30.24+00:00

Hi @database

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

database 40 Reputation points

2025-01-22T14:35:45.4+00:00

Hi Sina
Unfortunately
I still not found resolution

I have re-cross checked as you mentioned above messages and still has a questionsCheck if there are any network issues or timeouts causing the export to fail.

How can I check timeouts session can do? Because I try to upload file size around 20-25 gbs there a message "Out of memory"

And my BC SQL take capacity around 150 gbs right now. How can I know cause time out or out of memory. Cause I try to split file into 11gbs 17gbs many files can uploaded into this container

Business Central Admin Role: You should have SysAdmin or BCAdmin role in Dynamics 365 Business Central. -> My user used as "Super" and also "Administration Account" right now.

Azure Permissions: You need appropriate access to the Azure SQL Database resource (such as being a Contributor or Owner of the Azure SQL Database instance). Specifically, you need the permission to manage and export BACPAC files. -> It's has been set full access but still unable to do that as well

Sina Salam 16,446 Reputation points

2025-01-22T14:53:51.8333333+00:00

Dear database,

Thank you for your feedback. Let's break it down step by step:

Checking for Timeouts

You can check for timeouts in Azure SQL Database using several methods:

Extended Events: This is a powerful tool for monitoring and troubleshooting SQL Server. You can create an extended event session to capture timeout events. This is a guide on how to use Extended Events - https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-query-timeouts

Query Store: Azure SQL Database's Query Store can help you find queries that timed out. It captures a history of queries, their plans, and runtime statistics. You can use it to identify queries that are causing timeouts. More details can be found here - https://kendralittle.com/2022/03/11/find-execution-timeouts-query-store

Dynamic Management Views (DMVs): DMVs can provide insights into query performance and help identify long-running queries. You can use DMVs to monitor and diagnose performance issues. Get a good guide on using DMVs here - https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs?view=azuresql

Handling "Out of Memory" Errors

The "Out of Memory" error typically occurs when the system runs out of available memory to complete the operation. Here are some steps to mitigate this:

Increase Memory Allocation: Ensure that your Azure SQL Database has sufficient memory allocated. You might need to scale up your database to a higher service tier.

Split the BACPAC File: As you've mentioned, splitting the BACPAC file into smaller chunks can help. Ensure each chunk is within the memory limits of your system.

Optimize Queries: Optimize your queries to reduce memory consumption. This can involve indexing, query rewriting, or breaking down complex queries into simpler ones.

Ensuring Permissions

You've mentioned that you have the necessary permissions, but it's always good to double-check:

Azure SQL Database: Ensure you have the Contributor or Owner role on the Azure SQL Database instance.

Azure Storage Account: Ensure you have the Storage Blob Data Contributor role on the storage account where the BACPAC file is stored.

If you've verified all these steps and are still facing issues, it might be helpful to check for any network issues or timeouts that could be causing the export to fail or contact Microsoft Support by raising ticket via your Portal.

Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Microsoft Business Central 365 : Backup Database on cloud / azure service

1 additional answer

Your answer