Servers

    Microsoft SQL Server 2008 Service Pack 2

    Select Language:
    Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      10.00.4000.00

      File Name:

      SQLServer2008SP2-KB2285068-x86-ENU.exe

      Microsoft SQL Server 2008 SP2 Readme.htm

      SQLServer2008SP2-KB2285068-IA64-ENU.exe

      SQLServer2008SP2-KB2285068-x64-ENU.exe

      Date Published:

      8/22/2011

      File Size:

      284.8 MB

      16 KB

      343.4 MB

      349.8 MB

      KB Articles: KB2285068

        Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download. These packages may be used to upgrade any edition of SQL Server 2008. We remain committed to providing our customers with essential changes via Service packs. Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces support for a maximum of 15,000 partitions in a database, and includes SQL Server 2008 SP1 Cumulative Update 1 to 8.  While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. Microsoft SQL Server 2008 Service Pack 1 is not a prerequisite for installing SQL Server 2008 Service Pack 2.

        For more information about SQL Server 2008 Service Pack 2, please visit our Release Notes.

        What's New:
        • Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for Reporting Services integration with SharePoint products. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in to support the integration of SQL Server 2008 R2 report servers with SharePoint 2007 products. For more information see the “What’s New in SharePoint Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What's New (Reporting Services).
        • SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.
          • SQL Server 2008 Instance Management.With SP2 applied, an instance of the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2 Utility Control Point as a managed instance of SQL Server. For more information, see Overview of SQL Server Utility in SQL Server 2008 R2 Books Online.
          • Data-tier Application (DAC) Support.Instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.

        Please Note:  SQL Server 2008 SP2 applies only to the SQL Server 2008 release.  This service pack can not be applied on top of SQL Server 2008 R2.
    • Supported Operating System

      Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista

        • Windows 7; Windows Server 2003; Windows Server 2008; Windows Server 2008 R2; Windows Vista; Windows XP
        • 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, ia64)
          • 1GHz or faster processor
        • Minimum of 512 MB of RAM (1 GB or more recommended)
        • 675 MB of available hard disk space

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

        Step 1: Download and review the Setup Documentation.
        • To view the SQL Server 2008 SP2 Setup documentation on the local computer, do the following:
          • Download and run SqlSP2_setuphelp.exe.
          • Follow the instructions to extract the Help file.
          • Find the location on the local computer where you saved the SqlSP2_setuphelp.chm file.
          • Double-click SqlSP2_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 SP2 at a later time, click Save.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial