Upgrading to SQL Server 2008 R2

Last Post 27 May 2010 06:39 AM by keithbu. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Paul Taylor, Microsoft, SQL Product Manager
New Member
New Member

--
27 May 2010 06:29 AM
Re-posting Question in separate thread from WantToRunAgain

We are currently running SQL Server 2008 R2. When SQL Server 2008 RTM comes out, are we going to have to re-install SQL Server, or will the "upgrade" be more like installing a service pack?
keithbu
New Member
New Member

--
27 May 2010 06:39 AM
The question is a little confusing.

If you mean you are running SQL Server 2008 and wish to upgrade to 2008 R2 then yes you will be able to do an in-place update. Its a little more than applying a services pack but it will upgrade fine. Remember to do a backup first.

If you mean you are running SQL Server 2008 R2 CTP and wish to upgrade to 2008 R2 RTM then I would recommend re-installing. I would avoid upgrading from a pre-release version of any product to the RTM version on a production machine. An in-place upgrade will work in this scenario but its not a great idea.

There are very few changes in the relational engine between the two releases so souldn't find any issues when you do your regression testing.


Acceptable Use Policy
---