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?
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?
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