"Unable to upgrade database... because SQL Server of this version does not support non-release version of this database (539)" solution, sql539

Source: Internet
Author: User

"Unable to upgrade database... because SQL Server of this version does not support non-release version of this database (539)" solution, sql539

When you use SQL2012 to append a database, the following error is reported: "You cannot upgrade the database... because SQL Server of this version does not support non-release version (539) of the database ). You cannot open a database that is not compatible with this version of sqlserver.exe. The database must be created again ."

The details are as follows:

After retrieval, we found that 539 was the internal version number of the SQL Server 2000 database, that is, the database file to be appended was created by SQL Server, however, we know that the SQL Server 2012 database is incompatible with the SQL Server 2000 database. As shown in:

The database to be attached was created in SQL Server 2000, so the above error occurs. In this case, a specific solution is available: SQL Server 2000 database> (first appended to) SQL Server 2005/2008 (which can be completed on another machine or the virtual machine can be installed on the local machine, install SQL Server 2005/2008 on the VM)-> then detach the database, copy it to the target folder, and then attach it to SQL Server 2012.

The following lists the internal version numbers of all Microsoft SQL Server databases before SQL Server2012: (the internal version number of SQL Server2012 is 706)

 

 

Target SQL Server Version

 

Source SQL Server Version

 

Internal Database Version

 

SQL Server 2008 R2

 

SQL Server 2008 R2

 

665

 

SQL Server 2008

 

661

 

Sqlserver 2005 with vardecimal enabled

 

612

 

SQL Server 2005

 

611

 

SQL Server 2000

 

539

 

SQL Server 2008

 

SQL Server 2008

 

661

 

Sqlserver 2005 with vardecimal enabled

 

612

 

SQL Server 2005

 

611

 

SQL Server 2000

 

539

 

SQL Server 2005 SP2 +

 

Sqlserver 2005 with vardecimal enabled

 

612

 

SQL Server 2005

 

611

 

SQL Server 2000

 

539

 

SQL Server 7

 

515

 

SQL Server 2005

 

SQL Server 2005

 

611

 

SQL Server 2000

 

539

 

SQL Server 7

 

515

 

SQL Server 2000

 

SQL Server 2000

 

539

 

SQL Server 7

 

515

 

SQL Server 7

 

SQL Server 7

 

515

 

Through the above table, we can quickly understand the error prompt. If you want to view the SQL Server internal version number, you can also view it using the following SQL statement:

SELECT DATABASEPROPERTYEX('MASTER','VERSION')

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.