sqlsql-server-2008sql-server-2008-r2servicepacks

Does SQL Server 2008 Service Pack 2 Apply to SQL Server 2008 R2?


I've been using SQL Server 2008 R2 for my development. I noticed that service pack 2 for SQL Server 2008 just came out. However, I checked here and Microsoft does not provide a link to any of the service packs for SQL Server 2008 R2. So it is not clear to me whether or not I should apply their service pack to my instance of SQL Server 2008 R2.

Do I need to apply some version of service pack 2 to my instance of SQL Server 2008 R2?

Thanks.


Solution

  • No, SP2 for SQL 2008 cannot be applied to SQL 2008 R2, they are different product versions.

    Here's the 2008 SP2 announcement. In addition to some bug fixes, it does contain some updates that make it compatible with some SQL 2008 R2 features, but this patch can't be applied to R2.

    The current patch level for SQL 2008 R2 is Cumulative Update 3 (Announcement, KB article).