Click here to change the language. This page is 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 R2 SP1. You can download SQL Server 2008 R2 Service Pack 1 (click here to download it). You can download SQL Server 2008 R2 SP1 Express Edition at: http://www.microsoft.com/download/en/details.aspx?id=26729. This document also provides search tips to help you find more known issues in Knowledge Base (KB) articles on the Microsoft Support site for SQL Server 2008 R2. This Release Notes document and the KB articles supplement SQL Server 2008 R2 Books Online.
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 R2, see the SQL Server 2008 R2 Readme. The Readme is available on the installation media and from the Readme page.
If you have feedback about SQL Server 2008 R2, please submit it at Microsoft SQL Server Connect Feedback Center. For the latest documentation, view SQL Server 2008 R2 Books Online in the MSDN Library. You can also find our forums and other support on the Troubleshooting and Support page.
1.0 What’s New in Service Pack 1 2.0 Before You Install 3.0 How to Find More Known Issues
1.0 What’s New in Service Pack 1
2.0 Before You Install
3.0 How to Find More Known Issues
The following features are new in Service Pack 1 (SP1).
Data-tier Application Component Framework (DAC Fx) for improved database upgrades. The new Data-tier Application (DAC) Framework v1.1 and DAC upgrade wizard enable the new in-place upgrade service for database schema management. The new in-place upgrade service will upgrade the schema for an existing database in SQL Azure and the versions of SQL Server supported by DAC. A DAC 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.
For a list of the bugs that are fixed in SQL Server 2008 R2 Service Pack 1, see the master KB article.
The recommended disk space requirements to download, extract, and install SP1 are approximately 2.5 times the size of the specific package.
Symptoms
Consider the following scenario:
In this scenario, the uninstall action succeeds. However, the SQL Server service cannot start.
Cause
This problem occurs because the Agent XPs option is not enabled when SQL Server 2008 R2 runs the upgrade script for the msdb database. The upgrade script runs when the SQL Server service starts. The script runs a stored procedure that is related to the UCP. The stored procedure requires that the Agent XPs option be enabled.
Resolution
If you experience this behavior after removing SP1, follow these steps to work around the problem. To avoid the problem, perform these steps before removing SP1. 1) If SQL Server is running, stop the SQL Server service. 2) Enable trace flag 902 on the instance of SQL Server 2008 R2. To do this, follow these steps:
3) Right-click the SQL Server service, and then click Start. 4) If the SQL Server Agent service is running, right-click the SQL Server Agent service, and then click Stop. Set the Agent service start mode to Manual. 5) Open SQL Server Management Studio, and then connect to the instance of SQL Server 2008 R2. 6) Run the following statements: EXEC sp_configure 'show advanced', 1; RECONFIGURE; EXEC sp_configure 'allow updates', 0; RECONFIGURE; EXEC sp_configure 'Agent XPs', 1; RECONFIGURE; GO 7) Modify the extended property of the sysutility_mdw database back to the SQL Server 2008 R2 version. To do this, follow these steps:
8) If you have not yet uninstalled the service pack, uninstall it now. If you have already uninstalled it, continue to step 9. 9) In SQL Server Configuration Manager, right-click the SQL Server service, and then click Stop. 10) Remove trace flag 902 on the instance of SQL Server 2008 R2. To do this, delete ;–T902 from the string value that you updated in step 2. 11) Right-click the SQL Server service, and then click Start. 12) Right-click the SQL Server Agent service, view properties, and set the service start mode back to its original value. Then click Start to start the Agent service. 13) In SQL Server Management Studio, reconnect to the instance of SQL Server 2008 R2. 14) In Object Explorer, expand Management, right-click Data Collection, and then click Enable Data Collection.
Note: If data collection is already enabled, the Enable Data Collection item is unavailable.
We recommend that you view more known issues on the Microsoft Support site for SQL Server 2008 R2 or by searching for "SQL Server 2008 R2" on the main Microsoft Support Web site.
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. You can also find our forums and other support on the Troubleshooting and Support page.