question

MortazaSahar-2444 avatar image
0 Votes"
MortazaSahar-2444 asked ·

Unable to import database file to sql server management studio because of “file contains corrupted data”

I have been struggling with this for days.

I have received a backup database file from MSSQL, which has weird characters I'm not sure what type it is. I have attached it below.

9283-dbunicodereport.png


I used the method described in the Microsoft docs to import a database, but that failed and I received an error message like below.

9165-sqlimportreport.png




Please let me know what I can do import the database file.

Kind regards

azure-database-mysql
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MortazaSahar-2444
As conveyed if this is for On Prem SQL, please check on the forum MSDN for better traction and insight.
https://social.msdn.microsoft.com/Forums/en-US/newthread?category=sqlserver&forum=sqldatabaseengine&prof=required

Thanks
Navtej S

0 Votes 0 ·
DSPatrick avatar image
1 Vote"
DSPatrick answered ·

Maybe this one helps.

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/373198/lcs-exported-bacpac-file-contains-corrupt-data


--please don't forget to Accept as answer if the reply is helpful--


Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management


Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.





·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
1 Vote"
VaibhavChaudhari answered ·

Is this Azure SQL Database where you are trying to restore DB? If not and if it is on-premise SQL server, you can also post question in below forum -

https://social.msdn.microsoft.com/Forums/en-US/newthread?category=sqlserver&forum=sqldatabaseengine&prof=required




If the response helped, do "Accept Answer" and upvote it - Vaibhav

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.