SQL Server Attach database Hint "version 661, unable to open, support 655 version ..."

When we use other people to export the database, sometimes we will attach the database method, the other people export the database attached to our computer, then, perhaps you will encounter this problem, when attached, the prompt version of XXX, unable to open, support AAA version.

What's going on here?

Originally, the version number refers to the version number of SQL Server, such as version number 661 is SQL Server R2, version number 655 is SQL Server 2008, etc. It has an upward compatibility feature. Thus, the title means that the database you want to attach can only be run on SQL Server R2 and later, not on SQL Server 2008, so what do we do with this problem?

To deal with this problem, there are many ways, below I will say a I find and use the method, for reference only, if there is a better way to welcome communication.

1. Attach the database to the data containing SQL Server R2.

2. Open Management Studio, log on to the server, select the database to be transferred in the database, right--"task (T)"--"Generate Script (E) ...".

3. In the Generate and Publish Scripts window, click Next

4. "Select the database object to script", you can not set it, click "Next"

5. Click on the "Advanced" button to the right of [save to file], in the dialog box, set "script for server version" to "SQL Server 2008", set "type of data to script" to "schema and data". Choose where to save the script

6. Next, next step. Export complete

To put the exported program into SQL Server 2008, follow the steps below:

1. Open management Studio and log on to the server

2. Select the menu "File"--"open"--"file", select the. SQL script file, click the "Execute" button in the toolbar

3. Right-click "Database"--"Refresh" in Object Explorer on the left

To this end, "version number 661, cannot be opened, support version 655 and the following version ..." This error is solved. Of course, if you unload the database directly, in the case of SQL Server 2008R2, this problem can be solved perfectly.

SQL Server Attach database Hint "version 661, unable to open, support 655 version ..."