Database Cannot Be Upgraded Because Its Non Release Version 539
A database created by a more recent version of Microsoft SQL Server cannot be attached or restored to an earlier version. This restriction is there because an older version cannot know about file format changes that were introduced in the newer release.
- Database Cannot Be Upgraded Because Its Non Release Version 539 Version
- Database Cannot Be Upgraded Because Its Non Release Version 539 Full
- Database 'northwind' Cannot Be Upgraded Because Its Non-release Version (539)
If you attempt to attach a database to an earlier version, you will get SQL Server error 948
with the internal version numbers listed in the error message text:
Q: I want to upgrade from a pre-release version of SharePoint 2013. A: Upgrade from a pre-release version of SharePoint 2013 to the release version of SharePoint 2013 is not supported. Pre-release versions are intended for testing only and should not be used in production environments. Upgrading from one pre-release version to another is also. SQL Server 2012 Upgrade Technical Reference Guide White Paper (1) - Free ebook download as PDF File (.pdf), Text File (.txt) or read book online for free. How to upgrade to SQL Server 2012.
The internal database versions for SQL Server aren't clearly documented in the Microsoft documentation. To get the internal database version, you can use one of the following:
Database DatabaseName cannot be upgraded because it is read-only or has read-only files August 9, 2020 March 20, 2011 by Artemakis Artemiou A few days ago I was trying to attach some databases on a SQL Server 2005 instance.
SQL Server Version | Internal Database Version | Database Compatibility Level | Supported Database Compatibility Levels |
---|---|---|---|
SQL Server 2019 CTP 3.2 / RC 1 / RC 1.1 / RTM | 904 | 150 | 150,140,130,120,110,100 |
SQL Server 2019 CTP 3.0 / 3.1 | 902 | 150 | 150,140,130,120,110,100 |
SQL Server 2019 CTP 2.3 / 2.4 / 2.5 | 897 | 150 | 150,140,130,120,110,100 |
SQL Server 2019 CTP 2.1 / 2.2 | 896 | 150 | 150,140,130,120,110,100 |
SQL Server 2019 CTP 2.0 | 895 | 150 | 150,140,130,120,110,100 |
SQL Server 2017 | 868 / 869 | 140 | 140,130,120,110,100 |
SQL Server 2016 | 852 | 130 | 130,120,110,100 |
SQL Server 2014 | 782 | 120 | 120,110,100 |
SQL Server 2012 | 706 | 110 | 110,100,90 |
SQL Server 2012 CTP1 (a.k.a. SQL Server 2011 Denali) | 684 | 110 | 110,100,90 |
SQL Server 2008 R2 | 660 / 661 | 100 | 100,90,80 |
SQL Server 2008 | 655 | 100 | 100,90,80 |
SQL Server 2005 SP2+ with VarDecimal enabled | 612 | 90 | 90,80,70 |
SQL Server 2005 | 611 | 90 | 90,80,70 |
SQL Server 2000 | 539 | 80 | 80,70 |
SQL Server 7.0 | 515 | 70 | 70 |
SQL Server 6.5 | 408 | 65 | 65 |
SQL Server 6.0 | ? | 60 | 60 |
Legend: ? = still investigating, RTM = Release to manufacturing, SPn = Service Pack n, CTP = Community Technology Preview (beta release).
You can comment here. If you know of a internal DB version that we don't have listed here, please use the comments.
Database Cannot Be Upgraded Because Its Non Release Version 539 Version
I work on this site continuously and keep the information up to date. If it helps you, you can support me:
© 2007–2020 SqlServerBuilds.blogspot.com · Contact · Privacy policy
Database Cannot Be Upgraded Because Its Non Release Version 539 Full
Database 'northwind' Cannot Be Upgraded Because Its Non-release Version (539)
Other useful sites › Exchange Server Version List | SharePoint Server Version List | Microsoft Knowledge Base Monitoring