SQL SERVER – Services Pack 2 for SQL Server 2008 R2 – Microsoft SQL Server 2008 R2 Service Pack 2

Service packs are very critical and important. In the industry I have seen many people waiting for the first service pack to arrive before moving to opting the product. I often see it as a good practice because there are some unknown bugs or missed enhancements in original product which are later covered in the SP2. I believe it is not limited to SQL Server but pretty much true across most of the softwares. Here is a single suggestion, you may delay adopting the product but must not delay in adopting service packs. As soon as they are released, grab them, test them on your development thoroughly and move to production server after validating.

Microsoft has recently released SQL Server 2008 R2 service packs. Please note these are for SQL Server 2008 R2 and not for SQL Server 2008. They will not work on SQL Server 2008 but will work only on SQL Server 2008 R2. If you have  have a fresh install of SQL Server 2008 R2, you just have to download and install SP2 and there is no need to install SP1 as this service pack is cumulative SP and contains all the previous upgrades of SP1.

Microsoft SQL Server 2008 R2 Service Pack 2

Microsoft SQL Server 2008 R2 Service Pack 2 Express Edition

Microsoft SQL Server 2008 R2 Service Pack 2 Feature Pack

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

9 thoughts on “SQL SERVER – Services Pack 2 for SQL Server 2008 R2 – Microsoft SQL Server 2008 R2 Service Pack 2

  1. Great, now I have a lot of servers to patch when I get back from vacation :(
    Thanks for the heads up, and I completely agree patching is critical. I’m one of the subscribers to the approach of delaying in adopting a new SQL version until it has been out for a while or getting with with its first SP.

  2. “you just have to download and install SP2 and there is no need to install SP1 as this service pack is cumulative SP and contains all the previous upgrades of SP1″

    not exactly true – if you’ve installed latest CU for SQL Server 2008R2 SP1 you should wait 1-2 weeks till the CU#1 for SQL Server 2008R2 SP2 is released as the latest 2 CU for SP1 are not included in SP2.

  3. Trying to install SP2 on my server which is currently on RTM, and getting the following error in SQLSysClrTypes_Cpu64_1.log:

    *******************************************************************************************

    Microsoft SQL Server System CLR Types requires the .NET Framework version 2.0 or 3.0 or 3.5 or 4.0. Ensure that this requirement is fulfilled before installing Microsoft SQL Server System CLR Types.

    Action ended 8:18:59: CA_ErrorPrereqDotNet20Or30Or35Or40. Return value 3.

    *******************************************************************************************

    BUT, 2.0, 3.0, and 3.5 are all installed. Any ideas?

  4. I have SQL 2008 R2 SP1 Failover Cluster on Win 2008 R2 SP2 64x. To upgrade to the SQL Server 2008 R2 SP2, do I need to uninstall the SP1 first or can I simply apply the SP2 on top of it?

  5. I tried to install service pack 2 on MS SQL Server 2008 r2 RTM but I am getting error. Please check the below error code and suggest.

    Error result: 595541211
    Error code: 49957Error: Failed to run patch request for instance: MSSQLSERVER (exit code: -595541211)Please help me here and let me know if required any other info

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s