0

Are the SQL Server service packs 'cumulative' or 'incremental'?

The scenario is that we have a couple of instances running on SQL Server 2008 R2 RTM and we have been asked to patch it up to SP3 level. I'm not sure if I just apply SP3 or do I need to do SP1 - SP2 - SP3

2
  • SP's and CU's are cumulative. Go ahead apply SP3 it would include all fixes for SP1 and SP2.
    – Shanky
    Commented Apr 16, 2015 at 10:33
  • SQL Server 2008 R2 service packs are cumulative and can be used to upgrade all releases of SQL Server 2008 R2 to Service Pack 3. Commented Apr 16, 2015 at 10:51

1 Answer 1

5

SQL Server 2008 R2 service packs are cumulative and can be used to upgrade all releases of SQL Server 2008 R2 to Service Pack 3.

From http://www.microsoft.com/en-US/download/details.aspx?id=44271

Given the documentation, you should be able to go directly from SP0 to SP3.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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