[dba-SQLServer] Restoring a SQL2008 Db with 2005 Compatibility Level back on to SQL2005

Borge Hansen pcs.accessd at gmail.com
Thu Feb 10 23:02:30 CST 2011


Hi All,
I have problems doing a simple restore of a SQL2008 Db back on to an SQL2005
Server.

The Db originated from the SQL2005, was restored on to SQL2008 R2, have the
Compatibility level to SQL2005; haven't created any additonal object other
than some views and SPs...

Why do I have problems?
Complains about the media being incorrectly formed .....
??

Regards
Borge


More information about the dba-SQLServer mailing list