locked
In-place upgrade RRS feed

  • Question

  • Hi,

    We are looking to install Windows Server 2008 R2 Standard edition on a server currently running the Windows Server 2008 Standard edition. This server is also running SAGE ERP, which uses MS SQL Server 2008 database also running on this server.

    Could you suggest if an in-place upgrade is possible in this scenario, without losing any data and settings at all? Or, is it preferable to do a clean installation? What all should we be taking care of for this upgrade?

    Another important point to mention is that we are also looking to upgrade from MS SQL Server 2008 to MS SQl Server 2012. Again, is this possible without doing a clean installation from scratch?

    Regards

    Yagyesh

    • Moved by Iric Wen Wednesday, June 6, 2012 9:37 AM (From:SQL Server Migration)
    Tuesday, June 5, 2012 12:07 PM

Answers

  • Hello,

    Please upgrade the operating system first to Windows Server 2008 R2. Make sure you apply SP1 for Windows Server 2008 R2 since it is a requirement to upgrade SQL Server 2012. After that simply upgrade to SQL Server performing an in-place upgrade or side-by-side upgrade.

    I am not sure this procedure could affect SAGE, but Windows Server and SQL Server will OK.

    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by Iric Wen Monday, June 18, 2012 1:58 AM
    Tuesday, June 5, 2012 4:08 PM

All replies

  • Hello,

    Please upgrade the operating system first to Windows Server 2008 R2. Make sure you apply SP1 for Windows Server 2008 R2 since it is a requirement to upgrade SQL Server 2012. After that simply upgrade to SQL Server performing an in-place upgrade or side-by-side upgrade.

    I am not sure this procedure could affect SAGE, but Windows Server and SQL Server will OK.

    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by Iric Wen Monday, June 18, 2012 1:58 AM
    Tuesday, June 5, 2012 4:08 PM
  • As mentioned, you should upgrade the OS first and apply SP1. then follow this article to perform a SQL in-place upgrade

    http://msdn.microsoft.com/en-us/library/ms144267.aspx


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Tuesday, June 5, 2012 7:30 PM