[EN] SQL Server 2008 Service Pack 4 is available!

LOGO__SQLServer2008Very, very long awaited final Service Pack4 for Microsoft SQL Server 2008 is already available. This Service Pack 4 (build number 10.50.600.34) include whole previously published updates for Service Pack 3 and up to Cumulative Update 17 (sic!). And it is the last update for this platform, Microsoft will not release any Cumulative Update for Service Pack 4. So it is the same story like in my previous post: this is the last update for Microsoft SQL Server 2008.

You cand download this update form Microsoft Download Centre and you can get two files (for x86 and x64 platforms):

  • ENU\SQLServer2008SP4-KB2979596-x64-ENU.exe | 378.4 MB
  • ENU\SQLServer2008SP4-KB2979596-x86-ENU.exe | 310.9 MB

This package can be used for upgrading following SQL Server 2008 R2 editions:

  • SQL Server 2008 Enterprise Edition
  • SQL Server 2008 Developer Edition
  • SQL Server 2008 Standard Edition
  • SQL Server 2008 Evaluation Edition
  • SQL Server 2008 Workgroup Edition

 

In the same moment MIcrosoft released Microsoft® SQL Server® 2008 SP4 Feature Pack. It’s very important stand-alone packages which provide additional value of SQL Server 2008 R2 SP2. Here is the link for Knowledge Base Article and list of packages:

  • Microsoft ADOMD.NET 
  • Microsoft Analysis Management Objects 
  • Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider
  • Microsoft SQL Server 2008 Command Line Utilities 
  • Microsoft Connector 1.0 for SAP BI 
  • Microsoft SQL Server 2008 Management Objects
  • Microsoft SQL Server Remote Blob Store
  • Microsoft SQL Server 2008 Native Client
  • Microsoft Windows PowerShell Extensions for SQL Server
  • Microsoft SQL Service Broker External Activator 
  • Microsoft SQL Server System CLR Types 

and full list of downloadable files:

 

image

Please read more information on all of those products and updates under linked addresses:

 

More important notes from producer:

  • We are not releasing  SQL Server 2008 Express Service Pack 4 refresh.
  • We are not releasing IA64 packages of SQL Server 2008 Service Pack4. For IA64 it is recommended to apply the latest update we delivered on SQL Server 2008 Service Pack 3.
  • This Service Pack will not be available on Microsoft Update. To facilitate the deployment on your side you could either use custom rules in SCCM or local publishing in WSUS as explained here.
  • Slipstream technology is not available for SQL Server 2008. To slipstream a SQL Server 2008 with Service Pack 4 please see post.

[EN] SQL Server 2008 R2 Service Pack 3 is available!

LOGO__SQLServer2008SP3Long awaited Service Pack 3 for Microsoft SQL Server 2008 R2 is available from last week. This Service Pack 3 (build number 10.50.600.34) include whole previously published updates for Service Pack 2 and up to Cumulative Update 13. And it is the last update for this platform, Microsoft will not release any Cumulative Update for Service Pack 3.

You cand download this update form Microsoft Download Centre and you can get two files (for x86 and x64 platforms):

  • ENU\SQLServer2008R2SP3-KB2979597-x64-ENU.exe | 358.4 MB
  • ENU\SQLServer2008R2SP3-KB2979597-x86-ENU.exe | 247.2 MB

This package can be used for upgrading following SQL Server 2008 R2 editions:

  • SQL Server 2008 R2 Parallel Computing Edition
  • SQL Server 2008 R2 Datacenter Edition
  • SQL Server 2008 R2 Enterprise Edition and Developer Edition
  • SQL Server 2008 R2 Standard Edition
  • SQL Server 2008 R2 Web Edition
  • SQL Server 2008 R2 Workgroup Edition

 

In the same moment MIcrosoft released Microsoft® SQL Server® 2008 R2 SP3 Feature Pack. It’s very important stand-alone packages which provide additional value of SQL Server 2008 R2 SP2. Here is the link for Knowledge Base Article and list of packages:

  • Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
  • Microsoft® System CLR Types for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Remote Blob Store
  • Microsoft® SQL Server® 2008 R2 Native Client
  • Microsoft® SQL Server® 2008 R2 Command Line Utilities
  • Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2  The Microsoft SQL Server 2008 R2 Service Broker External
  • Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Shared Management Objects
  • Microsoft® SQL Server® 2008 R2 ADOMD.NET
  • Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Analysis Management Objects

and full list of downloadable files:

image

 

Please read more information on all of those products and updates under linked addresses:

 

More important notes from producer:

  • We are not releasing  SQL Server 2008 R2 Express Service Pack 3 refresh.
  • This Service Pack will not be available on Microsoft Update. To facilitate the deployment on your side you could either use custom rules in SCCM or local publishing in WSUS as explained here.
  • Slipstream technology is not available for SQL Server 2008 R2. To slipstream a SQL Server 2008 R2  with Service Pack 3 please see this post .
  • October 16th 2014: We have discovered an issue with Report Builder 3.0 that ships with SQL Server 2008 R2 Service Pack 3.You will find on the SQL Server Release Services blog a public message sharing details and mitigations.

[EN] SQL Server 2008 R2 SP2 Cumulative Update 11 is available

LOGO__SQLServer2008R2SP2Just only one updates package for SQL Server has been released in February. This Cumulative Update no 11 {build number: 10.50.4302.0} is for Microsoft SQL Server 2008 R2 with Service Pack 2. Microsoft resolved twelve errors. Here is the list of fixed bugs :

VSTS BUG: 1790001 | 2829845
FIX: "The provided statistics stream is corrupt" when you run the "UPDATE STATISTICS" statement against a table in SQL Server 2008 R2 or SQL Server 2012
SQL performance

VSTS BUG: 1635573 |2902151
FIX: Change Tracking incorrect current versions in database snapshots in SQL Server 2008 R2
SQL service

VSTS BUG: 1765040 |2912049
FIX: Memory leak occurs when an application that uses SQL Server Native Client tries to connect and close the connection to a SQL Server 2008 R2 instance
SQL connectivity

VSTS BUG: 1993304 |2919611
FIX: "Installer terminated prematurely" error when you install SQL Server 2008 SP3 or SQL Server 2008 R2 SP2
Setup & Install

VSTS BUG: 1915818 |2920987
FIX: Poor performance when many table-valued parameters are used in SQL Server 2008 R2
SQL service

VSTS BUG: 1993313 |2921630
FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008 or SSAS 2008 R2
Analysis Services

VSTS BUG: 1806945 |2922799
FIX: Unexpected exception is thrown when you convert writeback partition in SSAS 2008 R2
Analysis Services

VSTS BUG: 1993310 |2923837
FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008 or SQL Server 2008 R2
SQL service

VSTS BUG: 1917681 |2924996
FIX: Issues when you export a report to PDF with Unicode fonts in SQL Server 2008 R2
Reporting Services

VSTS BUG: 1972242 |2926699
FIX: Operating system version information that is returned from SQL Server 2008 R2 is incorrect in Windows 8.1
SQL service

VSTS BUG: 2004937 |2928669
FIX: The reports generated in SSRS 2008 R2 Report Manager are not compliant with Section 508 standards
Reporting Services

VSTS BUG: 1814380 |2929464
FIX: SELECT queries deadlock when ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2008 R2
SQL service

 

I f You ever read my posts about cumulative updates, you can see something special: the third, grey line. From this info release Microsoft make “public” one more part of this update -  Fix Area. That’s great, hope it helps all of SQL Folks with implementation of CU.

This update could be applied for: Microsoft SQL Server 2008 R2 Service Pack 2, when used with:

  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Reporting Services

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 11

You may have to restart the computer after you apply this cumulative update.

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for all platforms: 64-bit and ia64 and for 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

>> x86 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_x86
>> x64 | 2008R2_SP2_RSShrPnt_CU11_2926028_10_50_4302_x64
>> x64 | 2008R2_SP2_MDS_CU11_2926028_10_50_4302_x64
>> x64 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_x64
>> ia64 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_IA64

Enjoy!