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

File Contains Corrupted Data

(0) Share

Report

Posted on by john.ellis

3,518

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 97,970 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following will help.

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

Thanks.

ZHU

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

Like (0)

Report
Copy link

Link copied!

Good Morning:

Yes, I had followed those instructions.

Oh, well.

John

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,970 Super User 2026 Season 1 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

Was this reply helpful? Yes No
john.ellis 3,518 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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,970 Super User 2026 Season 1 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

Was this reply helpful? Yes No
john.ellis 3,518 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

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,970 Super User 2026 Season 1 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

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No