KB5030333 is the cumulative update number 23 for SQL Server 2019. It was released on 12 October 2023. The update is a major update as it fixes many bugs and issues in SQL Server 2019.
The content below caters to SQL Server 2019 installed on Windows Servers.
- KB5030333 is cumulative update number 23 for SQL Server 2019.
- KB5030333 CU 23 of SQL Server 2019 contains 24 fixes over the KB5027702 CU 22 version.
- KB5027702 was released on 14 August 2023. On 10 October 2023, KB5029378 was released with security fixes for the CU 22 of SQL Server 2019.
- KB5030333 corresponds to SQL Server 2019 version 15.0.4335.1. The file version is 2019.150.4335.1.
- KB5030333 also updates the Analysis Services to the product version 184.108.40.206, and the file version is 2018.150.35.41.
- KB5030333 can be applied to any SQL Server 2019 installation.
- The update file for KB5030333 is SQLServer2019-KB5030333-x64.exe. The file hash is C79367EF48F653A31F98BB8A0CACF382B1C59D290F48E2A6F19D0F6171B31421.
- To verify the file hash value, use the command –
certutil -hashfile SQLServer2019-KB5030333-x64.exe SHA256on the command prompt.
- This Cumulative Update includes all fixes from all previous RTM Cumulative Updates. Therefore, it can be installed to resolve issues fixed in any previous RTM Cumulative Update of SQL Server 2019.
KB5030333 can be applied automatically using the Windows Update program.
You can also deploy KB5030333 manually. For manual implementation, you can download the offline installer file in .exe format. The file can be downloaded from the Microsoft Update Catalog or the Microsoft Download Center. The direct download links for the SQL Server 2019 CU 23 are mentioned below.
- Download KB5030333 from the Microsoft Update Catalog Site
- Direct download link for KB5030333
- Download KB5030333 from the Microsoft Download Center
The size of the KB5030333 SQL Server 2019 CU 23 is 878.4 MB. The server will restart after the patch is installed. We suggest carrying out the deployment of KB5030333 in an organized change process.
KB5030333 – Changelog
There are 24 fixes or improvements in KB5030333. CU 23 makes for a major release of SQL Server 2019. The details of issue fixes are mentioned below in brief.
- 18 issues in the SQL Server Engine are resolved
- 2 issues in Master Data Services are fixed
- 2 issues in SQL Connectivity are fixed
- 2 issues related to SQL Setup are fixed
Brief details of the issues fixed are shared below.
SQL Server Engine issue fixes
|Bug/Issue reference||Issue description|
|1992459||Fixes an issue in which restoring a transaction log backup to the specific point in time fails with the following error:|
Msg 9003, Level 20, State 9, Line <LineNumber>
The log scan number (xxx:xxx:xxx) passed to log scan in database ‘DatabaseName’ is not valid.
|2584049||Enables IO error mode history in retail builds by using trace flag 3139 to allow the investigation of the assertion failure (Location: readEncoded.cpp:2988; Expression: m_pDecodeSplitInput->GetAvailableFreeSize () >= lengthInNext) that may occur while restoring transaction log backups|
|2374314||Fixes an issue in which an |
|2690338||Updates the design of |
Note: To apply this update, you need to set the
|2567537||Fixes an issue in which an availability group that has database level health detection enabled triggers needless failover for the following error 1105 when data files reach the limit size or the configured maximization:|
<DateTime> Error: 1105, Severity: 17, State: 2.
<DateTime> Could not allocate space for object ‘<TableName>’ in database ‘<DatabaseName>’ because the ‘<FilegroupName>’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
|2529767||Improves Data Definition Language (DDL) performance to create a large number of tables and partitions when the number of databases on a SQL Server instance exceeds 100.|
|2614132||Fixes a potential process termination issue that you might encounter when an |
|2647396||Fixes race conditions in which certain variables aren’t initialized correctly when a batch mode sort query is aborted, which causes an access violation and |
|2693198||Fixes an access violation exception that you encounter at |
|2590045||Fixes an issue in which the dynamic snapshot fails with the error “Arithmetic overflow error converting expression to data type int” in the |
|2602743||Fixes an issue that you encounter in the following scenario:|
– Configure the “Replication: agent custom shutdown” alert to respond to error 20578.
In this scenario, you notice that the “Replication: agent custom shutdown” alert doesn’t respond, which occurs as error 20578 isn’t logged in the application log.
|2614095||Fixes an issue in which the Snapshot Agent incorrectly generates the script of the |
|2646148||Fixes inconsistent results that you encounter when you use Read Committed Snapshot Isolation (RCSI) and the full-text index doesn’t pick up the updated data in an incremental crawl.|
|2621966||Fixes the following error 2570 that you encounter when you run |
Msg 2570, Level 16, State 3, Line <LineNumber>
Page (<PageID>), slot <SlotID> in object ID <ObjectID>, index ID <IndexID>, partition ID <PartitionID>, alloc unit ID <UnitID> (type “<Type>”). Column “<ColumnName>” value is out of range for data type “<DataType>”. Update column to a legal value.
|2633609||An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior.|
|2674865||Fixes error 207 (Invalid column name ‘<ColumnName>’) that you encounter when you run a user-defined function (UDF), which references a dropped column that uses data classification.|
|2639915||Adds a compressed memory dump feature that helps create a compressed memory stream to replace the conventional memory stream to speed up the dump process and reduce the size of the dump file. For more information, see Use the Sqldumper.exe tool to generate a dump file in SQL Server.|
|2640296||Fixes an issue in which SQL Server continues to generate new dump files when the dump file size is larger than 2 gigabytes (GB).|
SQL Setup issue fixes
The following 2 issues have been fixed in SQL Setup in KB5030333.
|Issue reference||Description of issue|
|2651628||Starting in SQL Server 2019 CU23, Azul Java is no longer available, and the Microsoft Build of OpenJDK 11 is provided instead.|
|2746708||Starting in SQL Server 2019 CU23, Azul Java is no longer available, and the Microsoft Build of OpenJDK 11 is provided instead.|
SQL Connectivity issue fixes
|2633976||Updates the version of the Microsoft ODBC driver to 220.127.116.11. For more information, see Release Notes for Microsoft ODBC Driver for SQL Server on Windows.|
|2633979||Updates the version of the Microsoft OLE DB driver to 18.6.7. For more information, see Release notes for the Microsoft OLE DB Driver for SQL Server.|
Master Data Services issue fixes
|Issue reference||Issue description|
|2593704||Fixes an issue that you encounter when selecting other non-entity nodes after selecting an entity node in Master Data Services models.|
|2654352||Fixes an issue in which you search for a specific node and then fail to expand the node on the hierarchy page.|
October 2023 Security Updates
You may be interested in reading more about other October 2023 security or cumulative updates shared below:
- KB5030333 SQL Server 2019 Cumulative Update 23
- KB5029378 SQL Server 2019 Cumulative Update 22 GDR
- KB5029503 SQL Server 2022 CU 8 Cumulative Update
- Windows 10 – KB5031377 Cumulative Update
- Windows 10 version 1809 – KB5031361
- Windows 10 version 1607 – KB5031362
- KB5031358 Cumulative Update for Windows 11 version 21H2
- KB5029377 Security Update for SQL Server 2019 GDR
- KB5031354 Cumulative Update for Windows 11 version 22H2
- KB5031356 for Windows 10 versions 21H2 and 22H2
- KB5031901 Update for .NET 7.0
- KB5031407 Security Update for Windows Server 2012 R2
- KB5031427 Security Update for Windows Server 2012
- KB5031419 Monthly Rollup for Windows Server 2012 R2
- KB5031442 Monthly Rollup Update for Windows Server 2012
- KB5031364 Cumulative Update for Windows Server 2022
- KB5031362 Cumulative Update for Windows Server 2016
- KB5031361 Cumulative Update for Windows Server 2019
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?
Rajesh Dhawan is a technology professional who loves to blog about smart wearables, Cloud computing and Microsoft technologies. He loves to break complex problems into manageable chunks of meaningful information.