web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Unable to restore Busi...
Small and medium business | Business Central, N...
Suggested Answer

Unable to restore Business Central bacpac into Azure Sql database

(0) ShareShare
ReportReport
Posted on by Community member

We have created a bacpac file from Business Central. It has created a bacpac file in Azure Storage Account. The file size is 4GB.

I then tried to import the database in Azure SQL. After nearly 20-30 minutes it failed with the error below:

The package file provided was not able to be opened. Please run SqlPackage locally to ensure that the file is not corrupt and please ensure that it uploaded to Azure Storage completely.

Then I downloaded the bacpac file onto my local computer and tried to restore it onto a new database in my local sql server using 'Import Data Tier Application' option. It failed immediately with the error below:

**Could not load package from 'C:....//ProductionXX_20230817_01.bacpac'. (Microsoft.SqlServer.Dac)

ADDITIONAL INFORMATION: File contains corrupted data. (Microsoft.Data.Tools.Schema.Sql) File contains corrupted data. (WindowsBase)**

We tried to generating another bacpac file from Business Central, but still getting the same errors.

Has anyone successfully imported a Business Central bacpac file into Azure SQL or On-premise sql server?

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator on at
    Did you make sure to go through all of these steps?
    And have you tried to redo the export to make sure nothing went wrong during your first export?
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,329 Super User 2025 Season 2 on at
    Hi, I have tested it before, and I have not encountered any problems. I hope the information below can give you some hints.
     
     
    Thanks.
    ZHU
  • Vikas Singh Profile Picture
    Vikas Singh 7 on at
    Hi @mayuran Para
    Were you able to fix this issue?
     
    I am running into the same issue. I tried both approaches - restoring it in Azure SQL Server and using SSMS and getting the error that the backup file is corrupt.
    I followed each and every step in the Microsoft documentation as well the in the article written by Yn Zhu but no luck.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans