Search code examples
sql-serversql-server-2008sql-server-2012database-restore

Restore a .bak file to a newer SQL server version

I'm facing a huge problem. I'm trying to restore a database to a newer version of SQL server. I have been told that it is possible to go upwards - to newer versions - but never backwards.

The .bak file was saved with SQL Server 2008 R2 (10.50.1600) and i'm currently working with SQL server version 2012

Unfortunately i read the following error:

The media family on device 'c:****' is incorrectly formed. SQL Server cannot process this media family.

Can anyone help me to restore this database? Thanks in advance

Solution

  • You can try generating script with 'Schema and data' option.