question

DavidZemdegs avatar image
0 Votes"
DavidZemdegs asked Cathyji-msft edited

SQL updates

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-general
sql.jpg (260.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DavidZemdegs avatar image
0 Votes"
DavidZemdegs answered ErlandSommarskog commented

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

Cheers
David Z

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The very top of the errorlog is the interesting part.

GDR in the context of SQL Server are typically security fixes. I can't say how they are identified in WSUS; I'm an SQL Server guy, not a Windows person.

0 Votes 0 ·
DavidZemdegs avatar image
0 Votes"
DavidZemdegs answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DavidZemdegs avatar image
0 Votes"
DavidZemdegs answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @DavidZemdegs,

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for that background. I still need to find out what has caused it.

0 Votes 0 ·

Hi @DavidZemdegs,

Any other applications that designed for manage software update are installed on your server ?

0 Votes 0 ·