Search

Monday, April 8, 2013

Error Message 3241

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:

  1. Create a blank database in SQL server 2005
  2. Generate the script using 'Generate Script Wizard'
  3. Now create structure of your database
  4. Finally use Import/Export data wizard to import your data.

3 comments:

  1. Hello Arun,

    Have you written this article or written by someone else?
    I have found exactly same article at here

    ReplyDelete
    Replies
    1. Hello Jyoti,

      My colleague faced this problem. I had searched for the solution on the net and found above solution.

      Delete