Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Upgrading to 2008 R2

Author  Topic 

scabral7
Yak Posting Veteran

57 Posts

Posted - 2013-02-14 : 10:53:58
Hi,

looking to Upgrade from SQL 2008 Enterprise to 2008 R2 Enterprise on Windows 2008 R2 Server (64 bit).

Any known issues, gotchas, white papers, etc... that I should be looking for or prepare for?

My guess is that an in-place upgrade should be quite easy as there should not be many changes from 2008 to 2008 R2.

thanks for your help.

Scott

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-14 : 12:50:32
Microsoft has a lot of useful well-organized information on how to upgrade, including an upgrade advisor. This is the link: http://msdn.microsoft.com/en-us/library/bb677622(v=sql.105).aspx

Take backups of everything, go through the documentation carefully, and upgrade. It should be rather painless (famous last words :)

Editing: The automatically inserted hyperlink above seems to take you to the 2012 site. If you copy the string I posted into a web browser, it should take you to the 2008 R2 site.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-16 : 06:21:14
SQL Server 2008 R2 Enterprise Edition uses 8 CPU as maximum . Datacenter is required if more than 8 CPU is required


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

pvssivakumar
Starting Member

8 Posts

Posted - 2013-02-19 : 06:37:07
NO DUDE PLS DO NOT GO FOR 2008 R2 IT IS OCCUPYING SO MUCH OF RAM TO LOAD ITSELF BETTER YOU GO DIRECTLY TO SQL 2012 AFTER KNOWING THE IFS AND BUTS.



quote:
Originally posted by scabral7

Hi,

looking to Upgrade from SQL 2008 Enterprise to 2008 R2 Enterprise on Windows 2008 R2 Server (64 bit).

Any known issues, gotchas, white papers, etc... that I should be looking for or prepare for?

My guess is that an in-place upgrade should be quite easy as there should not be many changes from 2008 to 2008 R2.

thanks for your help.

Scott



Siva
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-20 : 08:10:01
pvssivakumar - there are license cost implications for going to sql server 2012.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -