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.
| 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).aspxTake 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. |
 |
|
|
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 requiredJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
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 |
|
|
|
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 |
|
|
|
|
|
|
|
|
Upgrading to 2008 R2