how to upgrade SQL Server from 2005 to 2014 RRS feed

  • Question

  • hi i have installed sql server 2005 now i want to upgrade it to 2014 is it possible

    if yes tell me the procedure

    • Edited by Shanky_621MVP Saturday, October 15, 2016 3:43 PM formatting
    • Changed type Naomi N Sunday, October 16, 2016 7:49 AM question
    Saturday, October 15, 2016 2:12 PM


All replies

  • Hello,

    You can upgrade from SQL Server 2005 to SQL Server 2014  by performing an in-place upgrade using SQL Server 2014 media or you can choose installing a new SQL Server 2014 instance side-by-side with your existent SQL Server 2005 instance and migrate databases to the new version using backup/restore.

    Both methods are explained in detail on the following document:


    Hope this helps.


    Alberto Morillo

    Sunday, October 16, 2016 1:45 AM
  • go through this-


    Regards, S_NO "_"

    Sunday, October 16, 2016 6:01 AM
  • The supportability of those upgrade methods (backup/restore, detach/attach, or in-place upgrade) are documented in the “SQL Server 2014 Support for SQL Server 2005


    Please click Mark As Answer if my post helped.

    Sunday, October 16, 2016 1:14 PM