Click here to Skip to main content
15,663,639 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi i want to attach a database file mdf to sql server 2008 r2 or 2012.
but i get this error
[Msg 950, Level 20, State 1, Line 1
Database 'DatabaseName' cannot be upgraded because its non-release version (539) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database].
how can i solve this Error?
how can i convert a mdf file to other version?

1 solution

for SQL 2012 you can only attach / upgrade a database from SQL 2005 or newer (you can only attach databases from two version below)

if your database version 2000 or lower , attach the database to any of your lower edition (2005, 2008, 2008R2), upgrade the database level (database property) to latest version, detach it and attach it finally to your SQL Server 2012.
Share this answer
Javad Emsakpour 28-Dec-13 3:23am    
my source database version is 2008r2.
even when my source database version is 2008r2, and i attach to 2008 ,i get error.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900