SQL2005 Incompatibility?

[dbmcdonald]

So far I really love SQL Data Compare, BUT....

I just had a problem on the third use where I had:

Backed up a SQL2005 db (A)
Copied A to Dev machine running SQL Data Compare
Backed up SQL2005 db (B)
Copied B to Dev machine running SQL Data Compare
Restored A and B to a SQLExpress2008R2 into 2 db's that were setup with SQL2005 (90) compatibility
Used SQL Data Compare and merged A into B selectively (not through scripts)
Backed up new B SQL2005 db (which we will call C)
Restored C to original machine where A came from but
I get "SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally" which I would expect if I was not carefully that all db's were SQL 2005 version.

Why would I get this error? The only thing I can think of is that Data Compare did something to the db to make my 2005 server think it was 2008.

The work around I found was to:

Restore B over A
Run scripts generated by SQL Data Compare on B to make it C.

[Brian Donahue]

SQL Data Compare doesn't do anything to the database properties, it strictly creates SQL DML scripts. You can see what is in those scripts before you run them - there is never any CREATE or ALTER database statement.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[dbmcdonald]

Thanks for the reply. I am completely baffled as to why I had this problem then.