the media family on device '.bak' is incorrectly formed. sql server cannot process this media family

[Former Member]

Dear All

Do any one have such error message?

The bak file is created by my colleauge on her desktop. Then I copy and paste it on cloud's sql server.

When I create a tenant with this bak file, it show this message.

I am using window 2012 R2 and sql server 2008 R2.

Regards

Edmund

[luisdarui]

Hi Edmund,

This issue can have many causes I believe that the backup file is corrupted.

Question: how did you transfer this backup? Have you used FTP for example?

What is the complete error message?

Please see also the following Microsoft KB:

https://support.microsoft.com/en-us/kb/2849351

Regards, Luis

[Former Member]

Dear Luis

Since my sql server version is 2012, the backup file also 2012.

I restore it to 2008 R2 version.

I transfer this backup file by remote desktop connection.

Msg 3241, Level 16, State 13, Line 1

The media family on device 'C:\Share\Company Template\MasterDB.bak' is incorrectly formed. SQL Server cannot process this media family.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

except upgrade to 2012, any other solution?

Regards

Edmund

[luisdarui]

HI Edmund,

You cannot restore a backup taken in SQL Server 2012 into a SQL Server 2008 R2. You can only restore backups that were taken in the same version or in a lower relase, but not the opposite.

Check the Books Online for more help.

Regards, Luis

[Sriram2009]

Hi Edmund

I am not sure, Could you refer the link about the restore method.

Restore SQL Server 2012 backup to a SQL Server 2008 database? - Database Administrators Stack Exchan...

Regards

SS