Trace Id is missing

Copilot is your AI companion

Always by your side, ready to support you whenever and wherever you need it.
A picture of a dog with a pop up bubble saying Talk to Copilot and asking What celeb does my dog look like?

SQL Server 2008 Service Pack 4

Download SQL Server 2008 SP4

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:

    10.0.6000.29

    Date Published:

    9/30/2014

    File Name:

    ENU\SQLServer2008SP4-KB2979596-x64-ENU.exe

    ENU\SQLServer2008SP4-KB2979596-x86-ENU.exe

    File Size:

    378.4 MB

    310.9 MB

    KB Articles:

    KB2979596

    Microsoft SQL Server 2008 Service Pack 4 (SP4) is now available for download. While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. A few key enhancements for customers in Microsoft SQL Server 2008 Service Pack 4 are :
    • Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008 SP4. In addition, we have increased the performance & reliability of the setup experience.
    • In SQL Server Integration Services logs will now show the total number of rows sent in Data Flows.
    • Enhanced warning messages when creating the maintenance plan if the Shrink Database option is enabled.
    • Resolving database issue with transparent data encryption enabled and making it available even if certificate is dropped.
    • Optimized query outcomes when indexed Spatial Data Type column is referenced by DTA (Database Tuning Advisor).
    • Superior user experience with Sequence Functions (e.g Row_Numbers()) in a Parallel execution plan.

    Microsoft SQL Server 2008 Service Pack 3 is not a prerequisite for installing SQL Server 2008 Service Pack 4. These packages may be used to upgrade any of the following editions of SQL Server 2008:
    • Enterprise
    • Standard
    • Evaluation
    • Developer
    • Workgroup
    • Express

    SQL Server 2008 SP4 contains the cumulative updates of SQL Server 2008 SP3 cumulative update package 1 to 17, and fixes to issues that have been reported through our customer feedback platforms. These include supportability enhancements and issues that have been reported through Windows Error Reporting.



    For a detailed list of new features and improvements that are included in SQL Server 2008 SP4, review the Release Notes.
  • Supported Operating Systems

    Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Vista

    • Windows 7; Windows8, Windows Server 2003 Service Pack 2 and R2;Windows Server 2008 Service Pack 1 and Service Pack 2;Windows Server 2008 R2;Windows Vista Service Pack 1 and Service Pack2;Windows XP Service Pack 3
    • 32-bit systems (x86)
      • PC with Intel or compatible Pentium III 600 MHz or higher processor (1 GHz or faster recommended)
    • 64-bit systems (x64)
      • 1GHz or faster processor
    • Minimum of 512 MB of RAM (1 GB or more recommended)
    • 675 MB of available hard disk space

  • Note: You must have administrative rights on the computer to install SQL Server 2008 SP4. We recommend that you read the Release Notes and Readme before installing SQL Server 2008 SP4.

    Step 1: Download and review the Setup Documentation.
    • To view the SQL Server 2008 SP4 Setup documentation on the local computer, do the following:
      • Download and run SqlSP4_setuphelp.exe.
      • Follow the instructions to extract the Help file.
      • Find the location on the local computer where you saved the SqlSP4_setuphelp.chm file.
      • Double-click SqlSP4_setuphelp.chm to open the Help file.
    Step 2: Download the appropriate package by clicking one of the links below.
    • To start the installation immediately, click Run.
    • To install SP4 at a later time, click Save.

Follow Microsoft