This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 38%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Hi all,
I'm trying to migrate an old SQL Server 2008 R2 to another SQL Server 2008 R2 but whenever I try it returns this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device 'E:\BKPBANK\P11_PRD.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-3241-database-engine-error
------------------------------
BUTTONS:
OK
------------------------------
The installer is the same, the SP3 I applied, it's the same, the only difference between the versions is the (Hypervisor) on the newer server, I imagine maybe it's because the server is virtualized with Proxmox.
See the @@version of each one:
Old Server:
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19, 2014 12:21:34 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 17763: )
New Server:
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19, 2014 12:21:34 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 17763: ) (Hypervisor)
Anyone can help me how can I solve this problem?
Best Regards,
mano
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Alvaro Iark
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Hi @Alvaro Iark
2008 is a very old version.
Based on the error message, I found a post that you can refer to, maybe it can help you.
https://www.stellarinfo.com/blog/sql-database-error-3241-restore-headeronly/
Best regards,
Percy Tang
I'm trying to migrate an old SQL Server 2008 R2 to another SQL Server 2008 R2
You try to migrate from "very old" (and out-of-support) to also the same very old one?
The media family on device 'E:\BKPBANK\P11_PRD.bak' is incorrectly formed.
That message can have at least 2 causes
In addition, I would find a machine where I can install a newer version of SQL Server., to see if I can read the backup. Also, are you able to read the backup on what you think is the source server?
Very thanks, the problem really was in the corrupted backup, initially they assured that everything was ok, but later we identified that this was the problem.
Thanks for all.
Best Regards,
Alvaro