Upgrade types

  • Dear Experts

    Kindly can you explain in simple words what are in place upgrade and side by side upgrade, how they work

    kindly provide me by any good simple article.

    Thank you very much

  • An in-place upgrade is where you upgrade the existing SQL Server instance running on your server. A side-by-side upgrade is where you build a new server, install a later version of SQL and then migrate your databases.

    http://technet.microsoft.com/en-us/library/bb681075.aspx

  • DBA From The Cold (11/27/2014)


    A side-by-side upgrade is where you build a new server, install a later version of SQL and then migrate your databases.

    Or install a new instance on the server and move the databases over.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thank you all

    Thank you very much

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply