Small and medium business | Business Central, N...

File Contains Corrupted Data

(0) Share

Report

Posted on by john.ellis

3,534

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

All responses (9)

Answers (0)

Sort by

Suggested answer

YUN ZHU 103,672 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following will help.

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

Thanks.

ZHU
john.ellis 3,534 on at

Like (0)

Report
Copy link

Link copied!

Good Morning:

Yes, I had followed those instructions.

Oh, well.

John
Suggested answer

YUN ZHU 103,672 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

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 3,534 on at

Like (0)

Report
Copy link

Link copied!

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 103,672 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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 3,534 on at

Like (0)

Report
Copy link

Link copied!

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

Mahesh U 433 on at

Like (0)

Report
Copy link

Link copied!

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.
Suggested answer

YUN ZHU 103,672 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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
karsvh 27 on at

Like (0)

Report
Copy link

Link copied!

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?