Upgrade SQL 2008 to SQL 2008 R2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Upgrade SQL 2008 to SQL 2008 R2

26 posts, Page 1 of 3

1 2 3 »»»

Upgrade SQL 2008 to SQL 2008 R2

Rate Topic

Display Mode

Topic Options

Author

Message

xanthos

Posted Thursday, August 05, 2010 3:20 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 03, 2013 9:09 AM
Points: 267, Visits: 622

Has anyone performed an upgrade of SQL 2008 to SQL 2008 R2?

I'm running SQL2008 sp1 EE and am planning upgrading to SQL 2008 R2 EE.

Are there any known issues or is this a straight forward processs?

Post #964083

sql_lock

Posted Thursday, August 05, 2010 3:35 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 1,293, Visits: 1,540

First of all I would run the upgrade advisor (link below), once you have done this then test, test and more testing.

It should be straigth forward from a SQL point of view, but take into consideration 3rd party apps, SQL jobs etc.

In most of my upgrades they have not be inplace upgrade as I took the time to upgrade the h/w.

[url=http://www.microsoft.com/downloads/details.aspx?FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52&displaylang=en][/url]

Post #964092

Grant Fritchey

Posted Thursday, August 05, 2010 6:25 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 13,383, Visits: 25,187

Total agreement on upgrading the hard way. I've only done a few 2008 to R2 upgrades, but they've been seemless to the point of no one noticing. I'd just be sure that the databases being upgraded are not running in a compatibility level. I think you'd be more likely to hit issues there.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #964191

Fox87

Posted Tuesday, February 22, 2011 4:38 AM

SSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:47 AM
Points: 636, Visits: 384

Hi There,

The SQL Upgrade Advisor doesn't work if I run it on my SQL 2008 instance.
It give the following error:

SQL Server version: 10.00.4000 is not supported by this release of Upgrade Advisor, only SQL2000 or SQL2005 is supported.

Do you have any idea how I can run it or why it is giving me this error? The current version is:

Post #1067502

Grant Fritchey

Posted Tuesday, February 22, 2011 6:01 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 13,383, Visits: 25,187

Fox87 (2/22/2011)

Hi There,

The SQL Upgrade Advisor doesn't work if I run it on my SQL 2008 instance.
It give the following error:

SQL Server version: 10.00.4000 is not supported by this release of Upgrade Advisor, only SQL2000 or SQL2005 is supported.

Do you have any idea how I can run it or why it is giving me this error? The current version is:

I don't think there are any differences between 2008 & R2 for the upgrade advisor to deal with.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1067560

Mary Truesdell

Posted Monday, August 01, 2011 1:57 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 22, 2012 11:22 AM
Points: 10, Visits: 31

I am trying to upgrade from SQL 2008 to SQL 2008 R2 and it keeps failing to upgrade the database engine services. Can anyone help me figure out what I'm doing wrong?

Windows 7, 64 bit.
Running 2008 standard 2008 sp1 64 bit

upgrading to 2008 R2 standard 64 bit

Most of the upgrade succeeds but the database engine services fails to upgrade no matter what I do.

Thanks for any help!

-Mary

Post #1152132

Fox87

Posted Tuesday, August 02, 2011 1:55 AM

SSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:47 AM
Points: 636, Visits: 384

Thanks Grant,

I rebooted the server and changed the reg-edit files then it worked.
One thing I noticed the 2008 upgrade adviser doesn't pick up the custom assemblies issue as the R2 adviser.

Post #1152319

Fox87

Posted Tuesday, August 02, 2011 2:02 AM

SSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:47 AM
Points: 636, Visits: 384

Hi Mary,

Any other information in the Logs or Eventviewer?

Post #1152324

chandan_jha18

Posted Tuesday, August 02, 2011 2:06 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:04 AM
Points: 412, Visits: 1,672

Mary Truesdell (8/1/2011)

Why did you change anything in the registry? It is not something good to do. You needed to have an upgrade advisor of 2008 R2 version. And while upgrading what errors did you encounter or did you happen to read the setup log that appears at the end of every upgrade(successful or failed). Post those logs for someone to give you some advice.

Chandan

Post #1152326

Mary Truesdell

Posted Tuesday, August 02, 2011 9:40 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 22, 2012 11:22 AM
Points: 10, Visits: 31

I can copy and paste the info from the "summary" files in the installation log files. Would that help? Event viewer seemed to only give really vague errors.

Also, I didn't modify the registry, that was someone else who is having this problem.

Post #1152656

« Prev Topic | Next Topic »

26 posts, Page 1 of 3

1 2 3 »»»

Permissions