While attaching a .mdf file in SQL Server i got "non release version(539), not supported by this version" error. how to resolve it?

Question

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'user'. (Microsoft.SqlServer.Smo)

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Database 'jiaowu' 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.
Could not open new database 'jiaowu'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950)

Please help me.....

Answer 1

The version 539 shows that you are using the SQL Server 2000 and it is not supported in SQL Server 2012.

Please refer: Deprecated Database Engine Features in SQL Server

As far as the workaround is concerned you need to first link your SQL Server 2000 to the SQL Server 2005 or SQL Server 2008 and then take the backup and then attach it to SQL Server 2012.