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.

dbmcdonald

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