SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Will SharePoint Server 2010 SP1 be compatible for an upgrade to SQL Server 2008 R2 SP2 CU2 from Microsoft SQL Server 2008 R2 (RTM)?

If we upgrade(from Microsoft SQL Server 2008 R2 (RTM)) Is there any problem in SharePoint sites and farm level


  1. Operating System : Windows server 2008 R2 Enterprise SP1

  2. SQL Server Version: Microsoft SQL Server 2008 R2 (RTM)

share|improve this question

There are no breaking changes to the way SQL Server 2008 R2 works from RTM to SP2, there are many feature improvements and bug fixes to the SQL Server database engine (as well as Reporting Services, Integration Services and Analysis Services) but nothing that adversely affects the operation of an already healthy SharePoint installation.

It is safe (and highly recommended) to upgrade your SQL environment to 2008 R2 SP2 as soon as possible, as Microsoft may no longer support a SharePoint environment with the RTM of 2008 R2.

share|improve this answer
Thanks James. My farm is SharePoint 2010 SP1 . In this case, Is there any problem in sharepoint site level/farm level if upgrade Microsoft SQL Server 2008 R2 (RTM) SP2.CU2 from Microsoft SQL Server 2008 R2 (RTM). Please clarify my quey – Mohan Periyasamy Aug 1 '12 at 19:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.