How to restore a higher version of SQL Server to a lower version of SQL Server (reprinted)

This example restores sql2012 to sql2008.

The function to be implemented is to back up the sql2012 database to sql2008, the database name is test, and the two databases are on different computers.

Microsoft's software design is basically a new version compatible with the old version, the old version is incompatible with the new version

The steps are as follows:

1, first put the sql2012 in the database to be backed up to be compatible with 2008.

Right-sql2012 The database test-properties-options See as:

2. Right-test-task-Generate script, next-next arrival, point "advanced" option. Change "Script for SQL version" to the one you want to downgrade as "sql2008". Make sure you're done. A "script.sql" script file is generated.

3. The next step is to copy the sqlserver2012 source file to another computer. Because SQL Server is running, it cannot be replicated. So the first thing to do is "stop" SQL Server services.

4. Find the location of the SQL2012 database in the computer. Right-click "Database"-"file" will have the path, copy out these two files. This sqlserver2012 computer operation is complete.

5. Copy the above "Script.SQL" file and two data source files to the computer where sql2008 is located. In sql2008, "new"-"Query Manager". Drag the "Script.SQL" into it and you'll see the code.

Note the green section. The location of the database file that appears is the location of the sql2012 computer. You need to change these two addresses to the address of the two source files copied from the sql2008. By pressing the "F5" key, you can complete the demotion of the database from SQL2012 to SQL2008.

Ext.: http://zhidao.baidu.com/link?url=LB1Wwfv_bRDublbJ1hydia53XWfNFyaaaMnm_YX6XOgs1WlyhD0biBpnqhP7DMdHCooOMr5LIK5 _plu89mj4c5awnr3cf5bco0gghsoxiqo

How to restore a higher version of SQL Server to a lower version of SQL Server (reprinted)