Hi all,I backupped a database from SQL Server 2005, edited it locally in my SQL Server 2008 Express (with Tools) and then tried to restore it back to the 2005 server again. This didn't work and gave several errors in the 2005 server, depending on the way I tried to restore it - or re-attach it. The errors are:
Database cannot be opened becaus it is version 655. This server supports version 611 and earlier.
The media family on device 'C:\Temp\backup2008\backup2008.bak' is incorrectly formed. SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)In other words: the database/backup is just fine, but SQL 2005 just doesn't swallow it. I have already confirmed that the compatability level on SQL 2008 Express (localhost) is set to '90', by using select * from sys.databases, which should mean that it is backwards compatible. I have also tried both restoring through the Management Studio and by script, as well as (re-)attaching the files. I just can't get it to work...Somewhere, it sounds logic. On another level I fail to see the point of the compatability level in the options if this is not possible. Any advice? Or do I just have to forget about SQL 2008 on my working machine and rollback to SQL 2005?
View Complete Post