Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Unable to restore Busi...
Business Central forum
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:
Integration to Power BI, Power Apps, Power Automate and Dataverse
Data Migrations
  • Vikas Singh Profile Picture
    Vikas Singh 7 on at
    Unable to restore Business Central bacpac into Azure Sql database
    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.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,480 Super User 2024 Season 2 on at
    Unable to restore Business Central bacpac into Azure Sql database
    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
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    Unable to restore Business Central bacpac into Azure Sql database
    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?
     

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans