upgrade from SQL Server 2008 to SQL Server 2008 R2 ?

  • Not sure about licensing, we have installed a SQL Server 2008 Standard Edition (64-bit) server with SP1.

    At this time we are not ready to go to SQL Server 2012 but this is supposed to be a development environment for a production server that is SQL Server 2008 R2 with SP2 Enterprise Edition.

    Is it within licensing to "upgrade" [or would it just be applying an update?] to R2 SP2 ?

    If someone can clear up my confusion it will be appreciated.

  • They're two different versions with two different licenses. In licensing upgrading from 2008 to 2008 R2 is the same as upgrading from 2005 to 2008. R2 is not a patch or service pack.

    Now, if you bought licenses for 2008 R2 and accidentally installed 2008, then you can replace the instance with the correct version. If you bought 2008 licenses however you'd need to buy new for R2.

    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 Gail.

    I kind of thought that was the case. Since I am new here I will see if someone knows what the license was really for.

    At the least I can apply the latest 2008 SP.

  • ELLEN-610393 (10/15/2013)


    but this is supposed to be a development environment for a production server that is SQL Server 2008 R2 with SP2 Enterprise Edition.

    Look into sql server developer edition 2012 - with downgrade rights to sql server developer edition 2008 R2

  • And if your company has a Select Agreement, check into that also.

    As Gail says, big change in licensing model for 2012, so be sure to understand the implications.

  • inevercheckthis2002 (10/16/2013)


    ELLEN-610393 (10/15/2013)


    but this is supposed to be a development environment for a production server that is SQL Server 2008 R2 with SP2 Enterprise Edition.

    Look into sql server developer edition 2012 - with downgrade rights to sql server developer edition 2008 R2

    that too - Developer edition has Enterprise functionality, which you might need for a dev environment targeting Enterprise prod.

    Also a quick look into what Enterprise only features are being used is wise if upgrade will cost you.

Viewing 6 posts - 1 through 5 (of 5 total)

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