Upgrading to SQL Server 2008 R2

Last Post 27 May 2010 07:39 AM by keithbu. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Paul Taylor, Microsoft, SQL Product Manager
New Member
New Member

--
27 May 2010 07: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 07: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.
You are not authorized to post a reply.

Acceptable Use Policy