- The Cumulative Update 7 for SQL Server is plagued by a database snapshot reliability issue.
- No administrators of an SQL Server 2019 should install this update, as advised by Microsoft.
- To grow your business in no time, find out all about the best Windows hosting with SQL Server.
- Always keep an eye on the latest security stories and not only, by bookmarking our News Hub.
Cumulative Update 7 (CU7, KB4570012) was released in early September 2020 for the flagship database product Microsoft SQL Server 2019.
In spite of the initial joy surrounding the news, there’s a serious warning coming from Microsoft itself about this precise update.
More specifically, the Cumulative Update 7 has been withdrawn due to severe issues and should not be installed by the administrators of a Microsoft SQL Server.
Given the circumstances, Microsoft stated:
If you had downloaded the CU7 package file before Sep-23 2020, it is advised to not install it. Instead, wait for an upcoming SQL Server 2019 CU announcement.
What can I do if I’ve installed the SQL Server 2019 CU7?
Cumulative Update Package 7 for SQL Server 2019 included in its package a wide range of fixes that were released after the original version of SQL Server 2019.
Administrators of a Microsoft SQL Server 2019 were finally able to fix the assertion exception that occurs when they query the DMV sys.dm_hadr_automatic_seeding.
Moreover, they could finally disable Change data capture when a column is encrypted by the Always Encrypted feature.
This was also meant to update the SQL Server and Analysis Services components to more stable and secure builds, so plenty of users downloaded the update.
However, there is this confirmed reliability issue with the database snapshot feature in SQL Server 2019 CU7. Since it is a critical one, the company’s decision is also drastic.
The update was removed from the Download Center, the Microsoft Update Catalog, as well as Linux repositories.
If you’ve installed the update already, Microsoft suggests uninstalling it, until a new SQL Server 2019 CU is released.
If you also created a database snapshot with CU7 installed, then you should drop the snapshot before or after uninstalling CU7.
Microsoft revealed its plans to include a fix for this known issue in October’s Cumulative Update 8.
Does waiting for the SQL Server 2019 CU8 scheduled to be released after October 12 ruins your plans? Let us know if you miss the fixes in the now-pulled patch in the comments area below.