title
description
author
ms.author
ms.date
ms.service
ms.subservice
ms.topic
helpviewer_keywords
monikerRange

SQL Server 2008 R2 SP2 Release Notes

This Release Notes document describes known issues that you should read about before you install or troubleshoot Microsoft SQL Server 2008 R2 Service Pack 2.

MikeRayMSFT

mikeray

07/22/2020

sql

release-landing

conceptual

SQL Server 2008 R2 SP2

Release Notes, SQL Server 2008 R2 SP2

= sql-server-2016

SQL Server 2008 R2 SP2 Release Notes

[!INCLUDEsqlserver]
This Release Notes document describes known issues that you should read about before you install or troubleshoot Microsoft SQL Server 2008 R2 Service Pack 2. This Release Notes document applies to all editions of SQL Server 2008 R2 SP2 and is available online only. It is updated periodically.

1.0 What’s New in Service Pack 2

Added the dynamic management view (DMV) sys.dm_db_stats_properties. You can use this DMV to return statistics properties for a specified table or indexed view in the current database. For example, this DMV returns the number of rows that were sampled and the number of steps in the histogram.

2.0 Before You Install

For information about how to install [!INCLUDEsql2008r2] updates, see SQL Server 2008 R2 Servicing Documentation.

For general information about how to get started and install SQL Server 2008 R2, see the SQL Server 2008 R2 Readme. The Readme document is available on the installation media.

2.1 Choose the Correct File to Download and Install

Use the following table to determine which file to download and install. Verify that you have the correct system requirements before installing the service pack. The system requirements are provided on the download pages that are linked to in the table.

2.2 Setup Might Fail if SQAGTRES.dll Is Locked by Another Process

Issue: A SQL Server setup operation might fail with this error: Upgrading of cluster resource C:\Program Files\Microsoft SQL Server\MSSQL10_50.<Instance name>\MSSQL\Binn\SQAGTRES.DLL on machine <Computer name> failed with Win32Exception. Please look at inner exception for details. The root cause is that C:\Windows\system32\SQAGTRES.DLL is locked by another process and Setup was not able to update it.

Workaround: Rename C:\Windows\system32\SQAGTRES.DLL to a temporary name such as C:\Windows\system32\SQAGTRES_old.DLL, and then select the Retry option on the setup error message. That will allow Setup to continue. After a reboot, you can delete the temporary file C:\Windows\system32\SQAGTRES_old.DLL.

3.0 Known Issues Fixed in this Service Pack

For a complete list of bugs and known issues fixed in this service pack, see this master KB article.

See Also

How to determine the version and edition of SQL Server