SQL2005 Incompatibility?

dbmcdonalddbmcdonald Posts: 3
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.


Sign In or Register to comment.