When attaching a database to SQL Server, the following message is displayed: "version 661 cannot be enabled. Version 655 is supported ......", Sqlserver661655

When attaching a database to SQL Server, the following message is displayed: "version 661 cannot be enabled. Version 655 is supported ......", Sqlserver661655

When we use a database exported by someone else, sometimes We append the database exported by someone else to our computer by appending the database. In this case, you may encounter this problem, when appending, the system prompts that the version is XXX and cannot be opened. The AAA version is supported.

What's going on?

It turns out that the version number refers to the version number of SQL Server. For example, the version number 661 is SQL Server 2008 R2, and the version number 655 is SQL Server 2008. It features upward compatibility. It can be seen that the title means that the database you want to attach can only run on SQL Server 2008 R2 and later, and cannot run on SQL Server 2008, what should we do to solve this problem?

There are many ways to solve this problem. Next I will talk about a method I found and used for reference only. If there is a better method, please contact us.

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

2. Open Management Studio, log on to the server, select the database to be transferred from the database, right-click the database, and choose "task (T)"> "generate script (E )...".

3. In the "Generate and release scripts" window, click "Next"

4. "select the database object for which you want to write the script", and click "Next" without setting"

5. click the "advanced" button on the right of [Save to file]. In the dialog box, set "write script for Server version" to "SQL Server 2008 ", set "type of data to be written" to "Architecture and Data ". Select the location where the script is saved

6. Next step. Export complete

To put the exported program in SQL Server 2008, follow these steps:

1. Open Management Studio and log on to the server.

2. Select "file"> "open"> "file", select the. SQL script file, and click "execute" in the toolbar.

3. In the "Object Resource Manager" on the left, right-click "Database"-"refresh"

So far, "version 661 cannot be enabled. Version 655 and earlier are supported ......" This error is fixed. Of course, if you uninstall the database directly and Install SQL Server 2008R2, this problem can also be perfectly solved.