Link to home
Start Free TrialLog in
Avatar of fieldj
fieldjFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Upgrading Windows Server 2008 to Server 2008 R2 and SQL 2008 to SQL 2008 R2

Hi all,

We have a couple of servers running Windows Server 2008 with SQL 2008.  We need to upgrade both servers to WIndows Server 2008 R2 and SQL 2008 R2.

I just wanted to ask the experts about their experience of this procedure.

Are there any particularly good guides out there?
Are there any known issues that could occur?
What is the best sequence to complete the upgrade?

Thanks
Avatar of David Todd
David Todd
Flag of New Zealand image

Hi,

Installing SQL 2008R2 - even as a separate instance - will upgrade the tools to 2008R2.

Suggestion: Install 2008R2 as another instance, and then migrate the databases between instances ...

HTH
  David
Avatar of fieldj

ASKER

Hi David,

Why would it be a problem to upgrade the tools to 2008R2?
Hi,

No problem that I've found using the 2008R2 SSMS against earlier versions. But its been a while since using BIDS so can't comment about that.

I'm just saying so that it isn't a surprise and give you a fright. Maybe you're a bit more placid that me, but things that are different and unexpected really worry me when I can't explain them.

Regards
  David
Avatar of fieldj

ASKER

Ah, OK gotcha.  

I am not actually a SQL user, I will just involved in the installation.

However, we already have another instance of 2008R2 on another server that our DB admin uses so it shouldn't come as a surprise to him :)
Hi,

My job description should read something like this:

Personal Qualities
Picky
Pedantic
Paranoid
Not Prickly

Which is exactly what is wanted as a DBA ... <grin>

Regards
  David
from windows point of view,
if you upgrade from 32bit windows 2008, then you need to do a migration because there is no upgrade path to windows 2008 r2 (64bit)

you need to perform a miration to another server.
Hello

I hate to upgrade OS, always prefer a fresh install. If you have many servers you can swing some database betwen servers if you can simply go offline for 2hours one server.
If you had 32 bit version OS then don't worry, you have no other choice is a fresh install (can't upgrade), but I think the SQL install was on 64 bit platform.

Dan
Avatar of fieldj

ASKER

We have 64bit versions of Server 2008 so that is not a problem.

I know generally a fresh install is preferred to an OS upgrade but I am just not sure that is going to be practical.  I don't really know much about moving the DB's between servers so not really sure how easy that would be.
ASKER CERTIFIED SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial