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:
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.
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
