Share via


Microsoft SQL Server 2008 SP2 Release Notes

Click here to change the language.
 

.These release notes are carefully and closely monitored. Any changes you make will be evaluated and then quickly accepted, refined, or reverted. Because this is a wiki, additions or refinements to these release notes might have been made by community members. To read the original and official release notes document, click here.
 

This Release Notes document describes known issues that you should read about before you install or troubleshoot SQL Server 2008 SP2 (download it here). This document also provides search tips to help you find more known issues in Knowledge Base (KB) articles on the Microsoft Help and Support Web site. This Release Notes document and the KB articles supplement SQL Server 2008 Books Online.

This Release Notes document applies to the following products:

  • Microsoft SQL Server 2008 Standard

  • Microsoft SQL Server 2008 Standard Edition for Small Business

  • Microsoft SQL Server 2008 Developer

  • Microsoft SQL Server 2008 Enterprise

  • Microsoft SQL Server 2008 Express

  • Microsoft SQL Server 2008 Express with Advanced Services

  • Microsoft SQL Server 2008 Web

  • Microsoft SQL Server 2008 Workgroup

  • Microsoft SQL Server 2008 Analysis Services

  • Microsoft SQL Server 2008 Reporting Services

This Release Notes document is available only online, not on the installation media, and it is updated periodically.

For information about how to get started with installing SQL Server 2008, see the SQL Server 2008 Readme. The Readme is available on the installation media and from the Readme download page.

Contents

1.0 What’s New in Service Pack 2

2.0 Before You Install

3.0 Release Notes for the Original Release

4.0 How to Find More Known Issues

 

1.0 What's New in Service Pack 2

The following features are new in Microsoft SQL Server 2008 Service Pack 2 (SP2).

  • SQL Server Utility. After you apply SP2, an instance of the SQL Server 2008 Database Engine can be enrolled with a 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. After you apply SP2, instances of the SQL Server 2008 Database Engine support all DAC operations. 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 in SQL Server 2008 R2 Books Online.

  • Reporting Services in SharePoint Integrated Mode. SP2 provides updates for Reporting Services SharePoint integration. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in for SharePoint 2007 products. The new add-in supports the integration of SharePoint 2007 products with SQL Server 2008 R2 report servers.  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) in SQL Server 2008 R2 Books Online.

  • 15K Partitioning Improvement. SP2 introduces support for a maximum of 15,000 partitions in tables and indexes in the Enterprise, Developer, and Evaluation Editions of Microsoft SQL Server 2008 SP2. For details on how this support can be enabled and disabled, along with recommended operation parameters, see the white paper Support for 15000 Partitions (it opens in a Word document)..

[Top]

 

2.0 Before You Install Service Pack 2

For a list of the bugs that are fixed in SQL Server 2008 Service Pack 2, see KB article 2285068.

The recommended disk space requirements to download, extract, and install SP2 are approximately 2.5 times the size of the package. The sizes of the SP2 packages are listed below:

SQL Server Express Packages (download):

  • SQLEXPR32_x86 (can be installed on both 32-bit and 64-bit operating systems): 110 MB

  • SQLEXPR_x86 (can be installed on 32-bit operating systems): 96 MB

  • SQLEXPR_x64: 123 MB

All Other Editions of SQL Server:

  • X86: 300 MB

  • X64: 367 MB

  • IA64: 359 MB

2.2 SQL Server 2008 R2 Features are displayed in the SQL Server Setup Wizard when You Run the SQL Server 2008 Service Pack 2 Update

You might see SQL Server 2008 R2 features included in the list of features to be updated by the SQL Server 2008 service pack on the Select Feature or Ready to Update page. SQL Server 2008 R2 components are not affected by the SQL Server 2008 service pack update. No action is required.

You might see SQL Server 2008 R2 components in the list of features on the Select Feature or Ready to Uninstall page when removing a SQL Server 2008 service pack update. SQL Server 2008 R2 features are not uninstalled during this process. No action is required.

2.3 All Features of an Instance of SQL Server Must Be at the Same Version Level Before Applying a Cumulative Update

If you apply a SQL Server cumulative update to an instance of SQL Server where the features are not all at the same version level, the update will fail. To avoid this failure, you must ensure that all the features in an instance of SQL Server are at the same version of SQL Server.

[Top]

3.0 Release Notes for the Original Release

Before you install SQL Server 2008, read the following required actions and KB articles.

3.1 Required Actions

If you have installed Visual Studio 2008 or have installed prerelease versions of SQL Server 2008, you might have to perform prerequisite actions before you install SQL Server 2008. To determine which actions that you might have to perform, use the following table.

Visual Studio 2008 installation status

SQL Server 2008 installation status

Required action before you install SQL Server 2008

Is not installed.

Prerelease version was never installed.

No action is required.

Is not installed.

Prerelease version is currently or was previously installed.

Follow these steps:

  1. Uninstall the prerelease version of SQL Server 2008.

  2. Additionally, you might have to uninstall Visual Studio 2008 features that were added by a prerelease installation of SQL Server 2008. In Windows, use Add or Remove Programs and uninstall the following features if they are installed: Visual Studio 2008 Shell (integrated mode) and Visual Studio Tools for Applications 2.0.

Is installed, and the release version of Visual Studio 2008 Service Pack 1 (SP1) is not installed.

Prerelease version was never installed.

Perform one of the following options:

  • Install Visual Studio 2008 SP1 before you install SQL Server 2008.

  • Uninstall Visual Studio 2008, and then install SQL Server 2008. After SQL Server 2008 is installed, you can install Visual Studio 2008 and then install Visual Studio 2008 SP1.

  • Do not install the following components of SQL Server 2008 that require Visual Studio 2008: Management Tools (both Basic or Complete), Integration Services, and Business Intelligence Development Studio features. If you want to later install any of these features, you must first install Visual Studio 2008 SP1.

Is installed, and the release version of Visual Studio 2008 SP1 is not installed.

Prerelease version is currently or was previously installed.

Follow these steps:

  1. Uninstall the prerelease version of SQL Server 2008.

  2. Perform one of the following options:

    • Install Visual Studio 2008 SP1 before you install SQL Server 2008.

    • Uninstall Visual Studio 2008, and then install SQL Server 2008. After SQL Server 2008 is installed, you can install Visual Studio 2008 and then install Visual Studio 2008 SP1.

    • Do not install the following components of SQL Server 2008 that require Visual Studio 2008: Management Tools (both Basic or Complete), Integration Services, and Business Intelligence Development Studio features. If you want to later install any of these features, you must first install Visual Studio SP1.

Visual Studio 2008 SP1 release version is installed.

Prerelease version was never installed.

No action is required.

Visual Studio 2008 SP1 release version is installed.

Prerelease version is currently installed.

Uninstall the prerelease version of SQL Server 2008.

If you install Visual Studio 2008 after you have installed SQL Server 2008, you must install Visual Studio 2008 SP1 to have a supported configuration. Visual Studio 2008 SP1 is not required if you did not install the following features that require Visual Studio 2008: Management Tools (both Basic or Complete), Integration Services, and Business Intelligence Development Studio.

For more information about how to install SQL Server 2008 with Visual Studio 2008, see the blog entry SQL Server 2008, Visual Studio 2008 SP1, and .NET Framework 3.5 SP1 Explained on MSDN and KB article 956139. For more information about Visual Studio 2008 SP1, see this Visual Studio Web site.

Connecting to SQL Server 2008 from Visual Studio 2005 requires downloading and installing Visual Studio 2005 Support for SQL Server 2008.

3.2 Knowledge Base Articles to Read First

The following Knowledge Base (KB) articles highlight known issues that are important to read before you install SQL Server 2008. To find more KB articles about installation, use this Before You Install query.

KB ID

Summary

956139

Visual Studio 2008 SP1 may be required for SQL Server 2008 installations.

956427

You cannot add a cluster node when you install SQL Server 2008 Analysis Services and you do not install the SQL Server 2008 Database Engine.

956005

The status indicator for a SQL Server 2008 mirror database differs from SQL Server 2005.

955396

How to troubleshoot SQL Server 2008 Setup issues.

955399

If upgrade to SQL Server 2008 fails, uninstall the upgrade before retrying the upgrade.

955973

You might receive this error message when you try to upgrade to SQL Server 2008 on a computer that is running Windows Server: "Access to the path '<Path>\perf-MSSQL$SQL2008sqlctr.dll' is denied."

955389

How SQL Server 2008 updates what feature usage data to collect.

3.3 Error and Usage Reporting Help Button Does Not Respond

If you click the Help button in the SQL Server Error and Usage Reporting dialog box, it does not respond. To view the content, see Error and Usage Report Settings on MSDN.

[Top]

4.0 How to Find More Known Issues

We recommend that you view more known issues by searching for "SQL Server 2008" on the Microsoft Support Web site. To find KB articles on specific topics, click any of the following suggested searches, or create your own custom search strings.

You can also join the SQL Server Community to share your experiences and learn from other people who are using SQL Server 2008. For more information, see the SQL Server Community Web site.

Books Online is the primary documentation for SQL Server 2008. You can view SQL Server 2008 Books Online on MSDN, or download a stand-alone version from the SQL Server 2008 Books Online download page.

[Top]