SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Upgrading to 2008 R2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

scabral7
Yak Posting Veteran

57 Posts

Posted - 02/14/2013 :  10:53:58  Show Profile  Reply with Quote
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

3712 Posts

Posted - 02/14/2013 :  12:50:32  Show Profile  Reply with Quote
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
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 02/16/2013 :  06:21:14  Show Profile  Visit jackv's Homepage  Reply with Quote
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

India
8 Posts

Posted - 02/19/2013 :  06:37:07  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 02/20/2013 :  08:10:01  Show Profile  Visit jackv's Homepage  Reply with Quote
pvssivakumar - there are license cost implications for going to sql server 2012.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000