Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 - how to upgrade to R2 Expand / Collapse
Author
Message
Posted Friday, July 26, 2013 4:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 23, 2014 3:10 PM
Points: 175, Visits: 165
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
Post #1477929
Posted Friday, July 26, 2013 4:53 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:46 PM
Points: 42,462, Visits: 35,525
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 2008, MVP
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

Post #1477932
Posted Friday, July 26, 2013 4:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 23, 2014 3:10 PM
Points: 175, Visits: 165
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.
Post #1477935
Posted Friday, July 26, 2013 5:05 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, July 26, 2014 3:05 PM
Points: 330, Visits: 3,204
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.
Post #1477938
Posted Friday, July 26, 2013 5:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 23, 2014 3:10 PM
Points: 175, Visits: 165
Ok can anybody point me in the right direction of the 2008 R2 download installation media please?

Thanks
Post #1477940
Posted Friday, July 26, 2013 8:36 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:46 PM
Points: 42,462, Visits: 35,525
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 2008, MVP
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

Post #1478044
Posted Friday, July 26, 2013 8:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 23, 2014 3:10 PM
Points: 175, Visits: 165
Right, that makes sense then. I will enquire with the network manager regarding files and licenses.

Appreciate all the responses,

Thanks

Chris
Post #1478046
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse