Moving to 2008 Instance from 2005 default instance

Question

Moving to 2008 Instance from 2005 default instance

Daryl AZ

Hall of Fame

Points: 3087
More actions
March 29, 2010 at 2:07 pm

#213211

Currently I am researching our migration from Sql2005 - 2008. As a simple migration I was contemplating leaving SqlServer2005 installed and creating/installing a 2008 instance.
Take a backup/restore to 2008
map applications to boxname\instancename
migrate jobs
future: uninstall 2005
This seems like a very low risk path.
?
thanks
Daryl

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Do you have a dev environment or QA (UAT) environment where you can do this first? This would give you the opportunity to note anything you have missed or anything that breaks.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Daryl AZ Hall of Fame Points: 3087 More actions · Answer 2

I was actually on the 2008 install screen in our DEV environment, and decided a search and SQLServerCentral question for any known issues would be worth a day delay.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

You could do it this way. You will find that most of us are a little more cautious when dealing with production changes.

However, as long as you have full backups and the original instance - it could be done. I would still caution that some testing be done before releasing the new db world to the end-users.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Daryl AZ Hall of Fame Points: 3087 More actions · Answer 4

Very much agree on caution. That was the reason I was installing in DEV.

thanks