Upgrade sql 2005 to sql 2008

Question

Post reply

Upgrade sql 2005 to sql 2008

Rem70Rem

SSCertifiable

Points: 6166
More actions
August 16, 2010 at 8:04 am

#236668

Hi All,
I am trying to find the best way to upgrade a SQL 2005 (Microsoft SQL Server Standard Edition (64-bit)) to SQL 2008. I would like to do the upgrade on the server where sql2005 is running without have to build a separate instance of sql2008.
Where can I find the steps to achieve this? Any recommendations or things to be careful at?
Thanks

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

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

Rem70Rem SSCertifiable Points: 6166 More actions · Answer 1

Rem70Rem

SSCertifiable

Points: 6166

August 16, 2010 at 8:48 am

#1207407

I guess this is an 'inplace' upgrade.

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 2

Try the white paper from Microsoft under inplace upgrade section.

http://www.google.co.in/url?sa=t&source=web&cd=8&ved=0CDgQFjAH&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F5%2F3%2FD%2F53D72434-7BD5-41C6-A806-8212C1B0DCA1%2FSQL%2520Server%25202005%2520to%25202008%2520Upgrade%2520White%2520Paper.docx&ei=G-JxTJr3GZLKuAPJn61C&usg=AFQjCNH5e8-g6ZDiChJZn3xh7hOaHFg0Bw&sig2=JlRjcDHvH9NQAAPWpvcnzQ

Regards..Vidhya Sagar
SQL-Articles

jerry-621596 SSCertifiable Points: 6096 More actions · Answer 3

My understanding is that you want SQL2008 to be the default instance. If this is correct, you can uninstall SQL2005, install SQL2008, and attach the database. Make sure and script out any logins and such first.

The risk is that if anything goes wrong, you no longer have SQL2005 ready to go.

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 4

Are you using Clustering? Upgrade passive node(s), failover sql server to passive to make it active and then upgrade Active node which is now passive.

[font="Verdana"]--www.sqlvillage.com[/size][/font]

Rem70Rem SSCertifiable Points: 6166 More actions · Answer 5

It is a standalone SQL server where I have only 1 instance of SQL 2005 (default not named).

I was told that the in-place install feature is pretty stable. It is right?

Derrick Smith SSChampion Points: 10833 More actions · Answer 6

I have never had an issue with the in-place upgrade..just make sure you take a full back up of all your DBs, script out logins, jobs, linked servers, save SSIS/DTS packages, and anything else you may have added to it first.

If the in-place upgrade fails, just uninstall everything, install 2008, and rebuild.

And make sure you update statistics with fullscan on every table once you upgrade it and get it up and running.

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 7

Rem70Rem (8/25/2010)
It is a standalone SQL server where I have only 1 instance of SQL 2005 (default not named).
I was told that the in-place install feature is pretty stable. It is right?

You have correct information, In-place upgrade is stable. As Derrick Smith mentioned, make sure you perform backup. One thing I would like to add is to run dbcc checkcatalog also

[font="Verdana"]--www.sqlvillage.com[/size][/font]