SQL updates

David Zemdegs 1,586 Reputation points
2021-08-24T21:56:24.6+00:00

Greetings,
Our database administrator asked how a SQL update was applied to their SQL servers. He gave me an extract from a SQL log that looks like this:

126128-sql.jpg

I checked and confirmed that we do not deploy SQL CUs or SPs through WSUS.
I also checked the WSUS log going back to the start of the year and found no SQL updates being deployed.
What would cause this? Might it be a Windows server 2019 update or an update to .NET framework?
Thanks
David Z

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,897 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Erland Sommarskog 102.3K Reputation points
    2021-08-24T22:02:06.757+00:00

    Could be a GDR. They are pushed through Windows Update.

    Could be that someone ran the installation package for the update in question.

    Possibly, if the instance is tied to an application, an upgrade of the application could include an upgrade of SQL Server.

    On the other hand, an update to Windows or .NET Fx would not touch SQL Server.

    It would certainly help to see the beginning of the errorlog.

    0 comments No comments

  2. David Zemdegs 1,586 Reputation points
    2021-08-24T22:19:41.87+00:00

    Thanks - What is a GDR please?
    And what part of the error log might give more clues please?

    Cheers
    David Z


  3. David Zemdegs 1,586 Reputation points
    2021-08-24T22:49:37.457+00:00

    GDR = General Distribution Release. How are they identified in WSUS?

    0 comments No comments

  4. David Zemdegs 1,586 Reputation points
    2021-08-24T22:55:58.267+00:00

    These were the only WSUS updates installed:

    2021-07 Cumulative Update for Windows Server 2019
    2021-07 Cumulative Update for .NET Framework 3.5, 4.7.2 and 4.8 for Windows Server 2019
    2021-08 Servicing Stack Update for Windows Server 2019
    2021-08 Cumulative Update for Windows Server 2019
    2021-08 Cumulative Update for .NET Framework 3.5, 4.7.2 and 4.8 for Windows Server 2019

    Would any of these have caused SQL to update?

    0 comments No comments

  5. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-08-25T02:51:33.667+00:00

    Hi @David Zemdegs ,

    > What is a GDR please?

    Quote from this MS document;

    GDR (General Distribution Release): A GDR is typically associated with a critical patch release the product groups feels should be provided to and installed by the whole customer base. GDRs are often associated with security releases, or other critical fixes needed to mitigate a problem the majority of customers will experience when using our product.

    Please check your SQL server setup log to find the SQL server upgrade information. The setup log files are located at %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log by default.

    Refer to MS document View and Read SQL Server Setup Log Files.

    > Might it be a Windows server 2019 update or an update to .NET framework?

    No, these operations will not cause SQL server update.


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.