Compatibility Level: SQL Server 2005 (90) RRS feed

  • Question

  • Hi, I have a database created in sql server 2008 R2 with the compatibility level set to sql server 2005 (90). I was hoping that I could create a .bak file and restore to sql server 2005. However, sql server 2005 does not seem to be able to.

    'An exception occurred while executing a Transact-SQL statement or batch... The media family on device... is incorrectly formed. SQL Server cannot process this media family.'

    Is there a way that I can create a bak file to acheive this?

    Many thanks,


    Tuesday, November 20, 2012 8:13 PM


All replies