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

File Contains Corrupted Data

(0) Share

Report

Posted on by john.ellis

3,510

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

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

YUN ZHU 95,595 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following will help.

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

Thanks.

ZHU

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Good Morning:

Yes, I had followed those instructions.

Oh, well.

John

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,595 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,595 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mahesh U 433 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,595 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
karsvh 27 on at

Like (0)

Report

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?

Was this reply helpful? Yes No