Post reply

SQL Server 2008 - how to upgrade to R2

  • July 26, 2013 at 4:25 am

    #296009

    Hi,

    I'm looking for some guidance on upgrading SQL Server 2008 version 10.1.2531.0 up to R2 which I understand will be 10.5.xxx

    I have tried running the installer for R2 SP2 and R2 SP1 but the installer prevents the update saying

    The version of SQL Server instance MSSQLSERVER does not match the version expected by the SQL Server update. The installed SQL Server product version is 10.1.2531.0, and the expected SQL Server version is 10.50.1600.1.

    What is the next step? Clearly R2 SP1 is too much of a jump but I really have struggled to find any download in between.

    Thanks

  • July 26, 2013 at 4:53 am

    #1636092

    SQL 2005 R2 is a separate version, it's not a patch.

    You need to purchase a licence, download the full installation media and run an upgrade.

    What you're trying to do is the equivalent of applying a SQL 2008 patch to SQL 2005, it's not going to work.

    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

  • July 26, 2013 at 4:58 am

    #1636095

    Hi Gail,

    I don't have SQL Server 2005...it's SQL Server 2008 (10.1). I'm trying to upgrade from 2008 base to the R2 release. Forgive me if I'm mis-understanding the builds / numbers. I certainly don't have 2005 involved here.

  • July 26, 2013 at 5:05 am

    #1636097

    Gail's point still stands regarding 2008 to 2008 R2

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • July 26, 2013 at 5:10 am

    #1636098

    Ok can anybody point me in the right direction of the 2008 R2 download installation media please?

    Thanks

  • July 26, 2013 at 8:36 am

    #1636189

    Depends how you bought the licence.

    2008 to 2008 R2 is not a patch, it's not a free download. It's exactly the same in terms of versions as 2005 to 2008, different versions that require different licences, separate purchases.

    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

  • July 26, 2013 at 8:40 am

    #1636191

    Right, that makes sense then. I will enquire with the network manager regarding files and licenses.

    Appreciate all the responses,

    Thanks

    Chris

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

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