locked
Attach SQL Server 2000 database file to SQL server 2014 RRS feed

  • Question

  • HI All,

    I want to attach SQL Server 2000 database file to SQL server 2014, but this error message occurs,

    “Database db_14 cannot be upgrade because its non-release version (539) is not support by this version of sql server. You cannot open a database that is incompatible with this version of sql server ......". How to fix this?

    Thanks in advance.

    Best regards,

    Yanjin


    • Edited by Lcey Monday, December 8, 2014 2:32 PM
    Monday, December 8, 2014 2:29 PM

Answers

  • Hi Yanjin,

    You cannot directly attach a sql 2000 database on sql 2014. You need to first attach this on a sql 2005 or sql 2008 instance and then take the backup of that database and restore on 2014.

    This is because you can only directly upgrade to two versions higher.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com


    • Edited by Ashwin MenonEditor Monday, December 8, 2014 2:33 PM
    • Edited by Shanky_621MVP Monday, December 8, 2014 2:35 PM changed 2012 to 2014 as OP asked about 2014
    • Marked as answer by Charlie Liao Tuesday, December 9, 2014 1:42 AM
    Monday, December 8, 2014 2:32 PM
    Answerer
  • Do you mean that I need install SQL Server 2008(or R2?) or SQL Server 2005 first? and attach the SQL Server 2000 database file to it, then upgrade it to SQL Server 2014.

    Best regards,


    If you have SQl server 2008/2008 r2 in your environment no need to install just restore backup on this server and then it will be upgraded to 2008 version. Finally take backup of database again and restore it on 2014. If you don't have 2008/2008R2. I would suggest download evaluation version of SQL Server 2008. It is basically enterprise edition with 180 days validity. After installation restore backup on 2008 database and then backup again and restore on 2014.

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    • Marked as answer by Charlie Liao Tuesday, December 9, 2014 1:42 AM
    Monday, December 8, 2014 3:07 PM

All replies

  • Hi Yanjin,

    You cannot directly attach a sql 2000 database on sql 2014. You need to first attach this on a sql 2005 or sql 2008 instance and then take the backup of that database and restore on 2014.

    This is because you can only directly upgrade to two versions higher.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com


    • Edited by Ashwin MenonEditor Monday, December 8, 2014 2:33 PM
    • Edited by Shanky_621MVP Monday, December 8, 2014 2:35 PM changed 2012 to 2014 as OP asked about 2014
    • Marked as answer by Charlie Liao Tuesday, December 9, 2014 1:42 AM
    Monday, December 8, 2014 2:32 PM
    Answerer
  • This is because you can only directly upgrade to two versions higher.

    You are correct about SQL server 2000 cannot be upgraded directly to 2014. You mentioned 2012 so I updated it to 2014  as OP was asking to 2014. I hope I did correct

    Again there is no restriction from MS about direct upgrade supported to upto only 2 versions. I am saying this because you can directly upgrade SQL Server 2005 database to SQL server 2014 which is 3 Version behind 2014.

    See Version and Edition upgrade path supported


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Monday, December 8, 2014 2:39 PM
  • Thanks for correcting Shanky, I was under the impression that OP wanted to upgrade to SQL 2012.

    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Monday, December 8, 2014 2:45 PM
    Answerer
  • Hi Ashwin&Shanky,

    Thanks for your quick response, I'm very very appreciated.

    >> You need to first attach this on a sql 2005 or sql 2008 instance and then take the backup of that database and restore on 2014.

    Do you mean that I need install SQL Server 2008(or R2?) or SQL Server 2005 first? and attach the SQL Server 2000 database file to it, then upgrade it to SQL Server 2014.

    Best regards,

    Yanjin


    • Edited by Lcey Monday, December 8, 2014 3:01 PM
    Monday, December 8, 2014 3:01 PM
  • Do you mean that I need install SQL Server 2008(or R2?) or SQL Server 2005 first? and attach the SQL Server 2000 database file to it, then upgrade it to SQL Server 2014.

    Best regards,


    If you have SQl server 2008/2008 r2 in your environment no need to install just restore backup on this server and then it will be upgraded to 2008 version. Finally take backup of database again and restore it on 2014. If you don't have 2008/2008R2. I would suggest download evaluation version of SQL Server 2008. It is basically enterprise edition with 180 days validity. After installation restore backup on 2008 database and then backup again and restore on 2014.

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    • Marked as answer by Charlie Liao Tuesday, December 9, 2014 1:42 AM
    Monday, December 8, 2014 3:07 PM
  • HI Shanky,

    Thanks a million, you are a real walking "Encyclopadia Britannica".

    Now I attach my SQL 2000 database file to SQL 2014 successfully.

    Best regards,

    Yanjin 


    • Edited by Lcey Tuesday, December 9, 2014 2:33 AM update
    Tuesday, December 9, 2014 1:35 AM