You may get below error message on your screen during SQL server database restore:
“An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)"
Additional information:
The media family on device 'DataBkp.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)”
This generally happens due to many reasons but the most common reason is version mismatch between backup & restore SQL server (To perform backup & restore operation of your SQL server database, you will have required two SQL servers with same version or higher version). You can't restore a backup that was taken from higher version of SQL server to lower version of SQL server. You can not restore a data backup taken on SQL Server 2008 to SQL Server 2005. To solve this error you have to check the SQL Server version of both SQL Server. Run below command to check version:
Select @@version;
Go
If this command verifies that backup taken SQL server version is higher than restore SQL server version then you have two choice:
either
upgrade restore SQL server
or
restore backup on the higher version of SQL server.
Alternate Solution: You can also resolve SQL server error message 3241 by performing following steps:
“An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)"
Additional information:
The media family on device 'DataBkp.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)”
This generally happens due to many reasons but the most common reason is version mismatch between backup & restore SQL server (To perform backup & restore operation of your SQL server database, you will have required two SQL servers with same version or higher version). You can't restore a backup that was taken from higher version of SQL server to lower version of SQL server. You can not restore a data backup taken on SQL Server 2008 to SQL Server 2005. To solve this error you have to check the SQL Server version of both SQL Server. Run below command to check version:
Select @@version;
Go
If this command verifies that backup taken SQL server version is higher than restore SQL server version then you have two choice:
either
upgrade restore SQL server
or
restore backup on the higher version of SQL server.
Alternate Solution: You can also resolve SQL server error message 3241 by performing following steps:
- Create a blank database in SQL server 2005
- Generate the script using 'Generate Script Wizard'
- Now create structure of your database
- Finally use Import/Export data wizard to import your data.
