Cumulative Update #7 for SQL Server 2019 RTM (Removed)

[SrinivasSQL]

Edit (10/01/2020)

We beat our deadline to ensure those that had not removed CU7 could have a reliable path forward, so SQL Server 2019 CU8 is now available. See the announcement post here.

Edit (9/24/2020)

There is a known reliability issue with the database snapshot feature in SQL Server 2019 CU7, and it was removed from the Download Center, the Microsoft Update Catalog, and Linux repositories. The database snapshot feature is used explicitly with the CREATE DATABASE … AS SNAPSHOT OF syntax, and implicitly when running DBCC CHECKDB (and any of its subset commands) except when used with the TABLOCK option. 

A fix will be included in the upcoming SQL Server 2019 Cumulative Update 8 (CU8), tentatively scheduled for the week of October-12.

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 CU8 announcement.

If you have already applied SQL Server 2019 CU7, and you are using the database snapshot feature in the scenarios stated above, please uninstall it. If you created a database snapshot with CU7 installed, plan to drop the snapshot before or after uninstalling CU7. In case you decide to wait for CU8, still plan to drop the snapshots created with CU7.

To learn more about the release or servicing model, please visit:

• CU7 KB Article: https://support.microsoft.com/en-us/help/4570012
• Starting with SQL Server 2017, we adopted a new modern servicing model. Please refer to our blog for more details on Modern Servicing Model for SQL Server.
• Microsoft® SQL Server® 2019 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=100809
• Update Center for Microsoft SQL Server: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sq...

[ZenZei]

Any timing on the release of the updated CU? We have to schedule downtime and server reboots for this, and would like to know an approximate timeframe to un-install or not CU7. 

Ideally a quick hotfix would be preferrable.

[smilne]

Just what you want to see the same day after finishing a patch cycle!

ETA for this new CU (or a hotfix) would be ideal.

[camaro322hp]

I know bugs happen, but this is not instilling a lot of confidence in SQL 2019.  As others have asked, ETA for patch?

[marc3932]

any more details about the database snapshots issue? what the issue causes?

[dosmond37]

CU7 is required for SCOM 2019 which we are running. An update on the date of the upcoming release would be great.

[VikasRana2006]

@SrinivasSQL Could you please share more detail about this issue? And if this going generate the memory dump or crash sql service?

If we do not remove cu7 then will new cu7 get installed?

[Christian Araujo]

What other issues does it cause, only a crash when trying to generate a snapshot? If I have it installed but don't use snapshots or wouldn't run DBCC CHECKDB for the time being I'm going to be safe?

[Pedro Lopes]

@Christian Araujo there is no mention of any crash - please do not read more than what is stated. It is a reliability issue with the snapshots. If you don't use any of the affected scenarios, then it's up to you to decide whether to uninstall CU7 or not, while waiting for CU8.

[Christian Araujo]

Thanks @Pedro Lopes 

[Pedro Lopes]

@VikasRana2006 please see the update. There is no crash nor mem dump.