Upgrading to 2008 R2

Question

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

Answer 1

Hello,

If both versions of SQL Server belong to the same platform (x64 for example), then you can perform an in-place upgrade. If you are performing a cross-platform upgrade then the only option is a side-by-side upgrade.

Please read the following resources:

http://download.microsoft.com/download/F/6/0/F60A49FE-04AB-4B64-AF8A-D72ED07279B3/Upgrading_to_SQL_Server_2008_R2_Whitepaper_FINAL.docx

http://msdn.microsoft.com/en-us/library/bb677622(v=SQL.105).aspx

Running upgrade advisor is recommended.

Hope this helps

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Thank you Alberto.

I've run the wizard and the only issue found is that Books Online will be upgraded...

Thanks Again.

Answer 3

Hi,

No known issue. It should be a pretty smooth process.

---

Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

Waqas

MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
Twitter: @Waqas_m1
Linked In: http://www.linkedin.com/in/waqasm1