Security News > 2020 > October > Adventures in SQL Server 2019: Microsoft updates the update that broke the update

There was good news for administrators of Microsoft's SQL Server 2019 last night as Cumulative Update 8 emerged, fixing the borkage of its predecessor.

Things haven't been going well for the SQL Server 2019 servicing model: Cumulative Update 2 left the SQL Agent a bit unhappy.

Most recently Cumulative Update 7 suffered from a "Known issue" with database snapshots, which also affected that little-used command DBCC CHECKDB. Cumulative Update 8 arrived with little fanfare and, like its predecessor, applies to both the Linux and Windows incarnations of Microsoft's database engine.

In the case of SQL Server 2019's Cumulative Updates, confidence levels may not be particularly high at this stage since two of the eight were subsequently subject to hurried "For the love of God, don't install this one!" warnings from the Windows giant.

Despite Microsoft's insistence that customers should opt for "Ongoing, proactive installation of CUs as they become available", anyone pondering the update of production systems would do well to consider the company's final bit of advice: "We recommend that you test SQL Server CUs before deploying to production environments."

News URL

https://go.theregister.com/feed/www.theregister.com/2020/10/02/sql_server_cu8/