Recently, after the computer reinstall System, SQL Server 2008 was installed。 When attaching the database file, the discovery cannot be attached and the wrong version is indicated. Remember, the original database version is SQL Server 2008R2 cannot be attached directly because the high-version database files are not compatible. I have 10 a few such database files need to be attached to the database management tool, Baidu on the Internet after some, did not find any special shortcut. Finally, we had to choose the first of these numbers on the computer, export the data script, restore the database file through the data script to SQL Server 2008 The method in the database administration tool. When exporting, the first encounter small problem, lead re-SQL Server 2008
The operation process is as follows:
SQL Server 2008r2 database files are imported into a SQL Server 2008 database