| Author |
 Topic  |
|
|
scabral7
Starting Member
49 Posts |
 Posted - 02/14/2013 : 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
Flowing Fount of Yak Knowledge
1518 Posts |
Posted - 02/14/2013 : 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. |
Edited by - James K on 02/14/2013 12:51:31 |
 |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1773 Posts |
Posted - 02/16/2013 : 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 |
|
|
|
pvssivakumar
Starting Member
India
8 Posts |
Posted - 02/19/2013 : 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 |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1773 Posts |
Posted - 02/20/2013 : 08:10:01
|
pvssivakumar - there are license cost implications for going to sql server 2012.
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
| |
Topic |
|
Upgrading to 2008 R2
