SQL 2008 Upgrade to SQL 2008 R2 Upgrade and then SQL 2008 R2 to SQL 2008 R2 SP1 Upgrade

Question

Hi I have SQL server 2008 now first I want to upgrade it 2008 R2 and then I want to upgrade it to 2008 R2  SP1 so what steps I need taken also it will do upgrade for SSIS and SSRS also or what?

Also most important thing client told me that Reporting service should not go down and sharepoint integrated should also need to setup so please help me for the same.

Answer 1

Hello,

Using SQL Server 2008 R2 media, perform an in-place upgrade from SQL Server 2008 to SQL Server 2008 R2. Use the following guide to perform this upgrade.

http://msdn.microsoft.com/en-us/library/ms144267.aspx

Download and apply SP1 from the following link:

http://www.microsoft.com/en-us/download/details.aspx?id=26727

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 2

Would you please check-out below thread

http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/376097c9-396d-4baa-a93a-634aee2bf94f

for the downtime while upgrading and patching.

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.