KB4022619 - SQL Server 2014 Service Pack 3 release information
This article contains important information to read before you install Microsoft SQL Server 2014 Service Pack 3 (SP3). It describes how to get the service pack, the list of fixes that are included in the service pack, known issues, and a list of copyright attributions for the product.
Note This article serves as a single source of information to locate all documentation that's related to this service pack. It includes all the information that you previously found in the release notes and Readme.txt files.
More Information
How to get SQL Server 2014 SP3
SQL Server 2014 SP3 and Microsoft SQL Server 2014 SP3 Express are available for manual download and installation at the following Microsoft Download Center websites.
SQL Server 2014 SP3 |
|
SQL Server 2014 SP3 Express |
Note After you install the service pack, the SQL Server service version should be 12.0.6024.0. Microsoft SQL Server 2014 service packs are cumulative updates. SQL Server 2014 SP3 upgrades all editions and service levels of SQL Server 2014 through SQL Server 2014 SP3.
For more information about the cumulative updates that are available in SQL Server 2014, see SQL Server 2014 build versions .
List of improvements and fixes included in SQL Server 2014 SP3
Microsoft SQL Server 2014 service packs are cumulative updates. SQL Server 2014 SP3 upgrades all editions and service levels of SQL Server 2014 to SQL Server 2014 SP3. In addition to the fixes that are listed in this article, SQL Server 2014 SP3 includes hotfixes that were included in SQL Server 2014 Cumulative Update 1 (CU1) through SQL Server 2014 SP2 CU13.
Notes
-
Additional fixes that aren't documented here may also be included in the service pack.
-
This list will be updated when more articles are released.
For more information about the bugs that are fixed and enhancements that are included in SQL Server 2014 SP3, see the following Microsoft Knowledge Base articles.
Notes for this update
Additional resolutions
Resolutions to the following issues are also included in SQL Server 2014 SP3.
VSTS bug number |
Description |
---|---|
10766220 |
Fixes an issue in which distribution agent failed with 20598 (row not found) error when applying the replicated command |
10656209 |
Fixes an issue in which Access violation occurred when reading from audit trace |
10762682 |
Fixes an issue in which SQL Server crushed with assertion message when using the top script with negative number |
5646575 |
Fixes an issue in which SQL Server returns records multiple times when the query used the date types which decimal or numeric together with int. |
7800206 |
Fixes an issue in which ShortestLineTo() method returns incorrect result for the shortest distance. |
10288772 |
Fixes 1828 error when Adding more than one database file with the same logical name. |
10355597 |
Fixes an issue in which memory leaks when an exception has been thrown. |
10472856 |
Fixes an issue in which access violation occurs when using the script that have filter expression for filtered index and stats |
11990862 |
Fixes an issue in which you cannot get the database name in extended event xml_deadlock_report, it always display master database. |
11970514 |
You can create target table in filegroup by SELECT INTO script. |
11542215 |
Add more underlying processor information (such as number of sockets, number of physical cores on a socket, number of NUMA nodes) in the sys.dm_os_sys_info dynamic management view. |
11565697 |
Users can now query DATABASEPROPERTYEX([DatabaseName], 'lastgoodcheckdbtime') to obtain a single value representing the Date/Time of the last successful DBCC CHECKDB run on the specified database. |
11007718 |
Raise an error message when execute an UPDATE statement that references a non-existing partition function using the $PARTITION keyword. |
11269484 |
Adds the filegroup support to the SELECT INTO statement. This allows you to specify the name of the filegroup in which a new table will be created. The filegroup specified should exist on the database else the SQL Server engine throws an error. |
11542000 |
Adds a new DMV sys.dm_db_log_stats that returns summary level attributes and information about transaction log files of databases. |
11542049 |
Adds a new DMV sys.dm_db_log_info that returns the Virtual Log File (VLF) information about the transaction log files. |
11542050 |
Exposes the percentage of differential changes in the databases to help determine whether full database backup or differential backup is useful. |
11542051 |
sys.dm_tran_version_store_space_usage |
11542121 |
Improves the backup performance on computers that have large memory. |
11542133 |
Ensure database name information always included in the deadlock graph. |
Select the correct file to download and install
The SQL Server 2014 SP3 download page contains the system requirements for installing SQL Server 2014 SP3 and basic installation instructions. For additional documentation about how to upgrade installed 2014 SP3 components with a SQL Server 2014 servicing update, see Install SQL Server 2014 Servicing Updates.
Use the following table to identify the location and name of the file to download based on your currently installed version. The download pages provide system requirements and basic installation instructions.
Version you currently have installed |
Action you want to take |
File to download and install |
A 32-bit version of any edition of SQL Server 2014 |
Upgrade to the 32-bit version of SQL Server 2014 SP3 |
SQLServer2014SP3-KB3587061-x86-ENU.exe from here |
A 32-bit version of SQL Server 2014 RTM or SP1 Express or SP2 Express |
Upgrade to the 32-bit version of SQL Server 2014 Express SP3 |
SQLServer2014SP3-KB3587061-x86-ENU.exe from here |
A 32-bit version of only the client and manageability tools for SQL Server 2014 (including SQL Server 2014 Management Studio) |
Upgrade the client and manageability tools to the 32-bit version of SQL Server 2014 SP3 |
SQLManagementStudio_x86_ENU.exe from here |
A 32-bit version of SQL Server 2014 Management Studio Express |
Upgrade to the 32-bit version of SQL Server 2014 SP3 Management Studio Express |
SQLManagementStudio_x86_ENU.exe from here |
A 32-bit version of any edition of SQL Server 2014 and a 32-bit version of the client and manageability tools (including SQL Server 2014 RTM Management Studio) |
Upgrade all products to the 32-bit version of SQL Server 2014 SP3 |
SQLServer2014SP3-KB3587061-x86-ENU.exe from here |
No 32-bit installation of SQL Server 2014 Management Studio |
Install 32-bit SQL Server 2014 Management Studio including SP3 |
SQLManagementStudio_x86_ENU.exe from here |
No 32-bit version of SQL Server 2014 Express |
Install 32-bit SQL Server 2014 Express including SP3 |
SQLEXPR32_x86_ENU.exe from here |
A 64-bit version of any edition of SQL Server 2014 |
Upgrade to the 64-bit version of SQL Server 2014 SP3 |
SQLServer2014SP2-KB3587061-x64-ENU.exe from here |
A 64-bit version of SQL Server 2014 RTM or SP1 Express or SP2 Express |
Upgrade to the 64-bit version of SQL Server 2014 SP3 |
SQLServer2014SP2-KB3587061-x64-ENU.exe from here |
A 64-bit version of only the client and manageability tools for SQL Server 2014 (including SQL Server 2014 Management Studio) |
Upgrade the client and manageability tools to the 64-bit version of SQL Server 2014 SP3 |
SQLManagementStudio_x64_ENU.exe from here |
A 64-bit version of SQL Server 2014 Management Studio Express |
Upgrade to the 64-bit version of SQL Server 2014 SP3 Management Studio Express |
SQLManagementStudio_x64_ENU.exe from here |
A 64-bit version of any edition of SQL Server 2014 and a 64-bit version of the client and manageability tools (including SQL Server 2014 RTM Management Studio) |
Upgrade all products to the 64-bit version of SQL Server 2014 SP3 |
SQLServer2014SP2-KB3587061-x64-ENU.exe from here |
No 64-bit installation of SQL Server 2014 Management Studio |
Install 64-bit SQL Server 2014 Management Studio including SP3 |
SQLManagementStudio_x64_ENU.exe from here |
No 64-bit version of SQL Server 2014 Express |
Install 64-bit SQL Server 2014 Express including SP3 |
SQLEXPR_x64_ENU.exe from here |
For more information about how to upgrade your SQL Server installation to SQL Server 2014 SP3, see Supported Version and Edition Upgrades.
Uninstalling SQL Server 2014 SP3 (not recommended)
If , for any reason , you choose to uninstall SQL Server 2014 SP3, the uninstallation of SQL Server 2014 SP3 will not be blocked, and you will be able to uninstall SQL Server 2014 SP3 in the same manner as any other service packs. However, if you are running the Standard, Web, or Express edition of SQL Server , and you are using some new features that are unlocked only when you start SQL Server 2014 SP3 , you might experience errors or see databases left in a suspect state after the uninstallation of SQL Server 2014 SP3 . Even worse , if the system databases are using new features ( for example, partitioned tables in master databases ), this could prevent SQL Server instances from starti ng after you uninstall SQL Server 2014 SP3 .
We recommend that you verify that all the new features are disabled or dropped before you choose to uninstall SQL Server 2014 SP3 on editions other than the Enterprise edition. You cannot drop the memory_optimized_data filegroup. Therefore, if you have set up the memory_optimized_data filegroup on your database with SP2, you should not uninstall SQL Server 2014 SP3 . Otherwise, the database will get in to a suspect state, and the following entry will be logged in the e rror log:
DateTime spid15s Error: 41381, Severity: 21, State: 1.
DateTime spid15s The database cannot be started in this edition of SQL Server because it contains a MEMORY_OPTIMIZED_DATA filegroup. See Books Online for more details on feature support in different SQL Server editions.-
This product contains software derived from the Xerox Secure Hash Function.
-
This product includes software from the zlib general purpose compression library.
-
Parts of this software are based in part on the work of RSA Data Security, Inc. Because Microsoft has included the RSA Data Security, Inc., software in this product, Microsoft is required to include the text below that accompanied such software:
-
Copyright 1990, RSA Data Security, Inc. All rights reserved.
-
License to copy and use this software is granted provided that it is identified as the "RSA Data Security, Inc., MD5 Message-Digest Algorithm" in all material mentioning or referencing this software or this function. License is also granted to make and use derivative works provided that such works are identified as "derived from the RSA Data Security, Inc., MD5 Message-Digest Algorithm" in all material mentioning or referencing the derived work.
-
RSA Data Security, Inc., makes no representations concerning either the merchantability of this software or the suitability of this software for any particular purpose. It is provided "as is" without express or implied warranty of any kind.
These notices must be retained in any copies of any part of this documentation or software.
-
-
The Reporting Services mapping feature uses data from TIGER/Line Shapefiles that are provided courtesy of the United States Census Bureau (Census.gov). TIGER/Line Shapefiles are an extract of selected geographic and cartographic information from the Census MAF/TIGER database. TIGER/Line Shapefiles are available without charge from the United States Census Bureau. To get more information about the TIGER/Line shapefiles, go to TIGER/Line shapefiles. The boundary information in the TIGER/Line Shapefiles is for statistical data collection and tabulation purposes only; its depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority, rights of ownership, or entitlement, and does not reflect legal land descriptions. Census TIGER and TIGER/Line are registered trademarks of the United States Census Bureau.
Copyright 2012 Microsoft. All rights reserved.
References
For more information about how to determine the current SQL Server version and edition, select the following article number to go to the article in the Microsoft Knowledge Base:
321185How to identify your SQL Server version and edition
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.