Shulou(Shulou.com)05/31 Report--

Today, let's talk to you about what to do if you can't open the database with version 655 of 'SqlPersistenceService'. Maybe many people don't know much about it. In order to make you understand better, the editor summarizes the following content for you. I hope you can get something according to this article.

"the version of 'SqlPersistenceService' is 655 and cannot be opened. This server supports version 611 and lower" problem

The following problems are encountered with the attached database:

The database 'SqlPersistenceService' is version 655 and cannot be opened. This server supports version 611 and earlier.

The downgrade path is not supported. Unable to open new database 'SqlPersistenceService'. CREATE DATABASE aborted.

Reason:

Version 655 refers to SQL2008, version 611 refers to SQL2005, (and version 539 refers to SQL2000)

The situation of the landlord is a typical situation in which the use of the high version is reduced to the lower version.

According to Microsoft's official statement, it is not supported to attach from a high version to a lower version.

What if it has to be done? There is a way.

First, find a computer with SQL Server 2008 and attach your database files to this computer.

After the attachment is successful, right-click the newly attached database in the object Explorer window of SSMS, select "Task > generate script." the script wizard dialog box will pop up.

Click next.

Select the newly attached database in the Select Database dialog box and tick "script all objects in the selected database" at the bottom. Click the next step.

In the Select script options dialog box, you also need to modify the following options:

1). "script data", set to "True"; (SQL2005 does not have this option, so you need to find a computer with SQL2008, which is so convenient and saves the trouble of data import and export.)

2). "script triggers", set to "True"

3). Write a script to create the database, set to "True"

4). "script the server version", select "SQL Server 2005"; (if you want to use SQL2000, select SQL Server 2000)

The above four options are highly recommended, the other options are up to you, and the others generally do not need to be changed. Click the next step.

In the output options dialog box, select Save script to File, other defaults, click next.

Finish at one o'clock.

Close at one o'clock.

Then copy the script file you just generated to your own computer, open it in SQL Server 2005 and execute the script. Note: before executing the script, be sure to modify the physical paths of the mdf and ldf files specified in the script to meet your own requirements.

After reading the above, do you have any further understanding of what to do if you can't open the database with version 655 of SqlPersistenceService'? if you want to know more about it, please follow the industry information channel and thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.