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... / File Contains Corrupte...
Small and medium business | Business Central, N...
Suggested answer

File Contains Corrupted Data

(0) ShareShare
ReportReport
Posted on by john.ellis 3,494

Hi:

I'm trying to import the Business Central database backup file (.bacpac) into SQL Server Management Studio.

Unfortunately, I receive the error below saying that the "file contains Corrupted data".

How do I get past this error?

Thanks!

John

pastedimage1658175115703v1.png

  • karsvh Profile Picture
    karsvh 27 on at
    RE: File Contains Corrupted Data

    I have the same problem. I exported 2 times and both times the bacpac file generated from BC cloud environment cannot be imported because of corrupted data. 
    The bacpac file does open in 7-zip and looks like all the data is there. Looks like the bacpac file from BC are corrupted anyway?

    Screenshot-2022_2D00_09_2D00_23-165910.pngpastedimage1663945229515v1.png 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 81,970 Super User 2025 Season 1 on at
    RE: File Contains Corrupted Data

    Hi, what if I choose Open directly?
    And I agree with Mahesh, maybe it's really a file problem, you can try re-exporting it again.

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Mahesh U Profile Picture
    Mahesh U 425 on at
    RE: File Contains Corrupted Data

    Hi John,

    why dont you create a anothe bacpack from database and try with that backup. I am assuming something interrupted your bacpac while you exporting.

    See if it helps.

    Regards,

    Mahesh U.

  • john.ellis Profile Picture
    john.ellis 3,494 on at
    RE: File Contains Corrupted Data

    Hi:

    I downloaded and installed 7-Zip.  

    Then, in 7-Zip, I chose "Extract" and selected the .bacpac file.

    Instead of extracting its contents, it zipped the file!

    What did I do wrong?

    John

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 81,970 Super User 2025 Season 1 on at
    RE: File Contains Corrupted Data

    Hi, the bacpac file itself is a zip file in disguise, if you can't open it with software like 7-zip, I think it's corrupted.

    For example, 

    https://techcommunity.microsoft.com/t5/azure-database-support-blog/editing-a-bacpac-file/ba-p/368931

    Sorry for not being able to help you more, hope other experts have better advice.

    Thanks.

    ZHU

  • john.ellis Profile Picture
    john.ellis 3,494 on at
    RE: File Contains Corrupted Data

    Hi:

    It wasn't zipped.  It is, in fact, a .bacpac file and not a .zip file.

    I have the latest version of SSMS.

    Thanks!  :)

    John

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 81,970 Super User 2025 Season 1 on at
    RE: File Contains Corrupted Data

    Hi, Can you unzip this bacpac file? If there is an error, maybe the file is really corrupted .

    pastedimage1658269746403v1.png

    pastedimage1658269770030v2.png

    And it is recommended to try with the latest SSMS.

    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

    Hope this helps.

    Thanks.

    ZHU

  • john.ellis Profile Picture
    john.ellis 3,494 on at
    RE: File Contains Corrupted Data

    Good Morning:

    Yes, I had followed those instructions.

    Oh, well.

    John

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 81,970 Super User 2025 Season 1 on at
    RE: File Contains Corrupted Data

    Hi, hope the following will help.

    https://yzhums.com/5010/#toc3

    Thanks.

    ZHU

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,424 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,043 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans