views:

798

answers:

1

Someone sent me a MDF file that was created in SQL 2008. I have SQL 2005, and the "Attach" function is rejecting the MDF file.

How can I import this file?

+3  A: 

You can't. You need to attach to a SQL 2008 instance and synch/BCP/SSIS the schema and contents.

Blogged yesterday by Paul Randall referring to SQL Server 2008/SQL Server 2008 R2 differences

gbn
ugh. Not the answer I wanted, but accurate enough for answer credit... ;)
Shaul