Post reply

Sql Server security updates on

  • May 29, 2022 at 8:56 am

    #4041027

    Microsoft recommends to install the latest security updates , does that mean I can just install the latest security update without the need to install the last 2 or 3 updates if I haven't installed them

  • May 30, 2022 at 9:10 am

    #4041450

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • May 30, 2022 at 7:04 pm

    #4041703

    With SQL Server 2019, Microsoft doesn't release "Security Updates".  All you get are CU's or GDR's and both of these are cumulative update which includes all previous patches.  You just don't want to do both CU's AND GDR's... it is an either-or situation.

    BUT if you are ever in doubt, I recommend doing a search for something along the lines of "SQL Server 2019 upgrade path" and then include the CU you are updated to and wanting to go to.  For example "SQL Server 2019 upgrade path CU1 to CU3".  Second link gives you the different upgrade paths for SQL 2019 and nothing in there indicates that CU2 must be installed before CU3.  ALSO, if you check the release notes for CU3 (https://support.microsoft.com/en-us/topic/kb4538853-cumulative-update-3-for-sql-server-2019-04829099-2b9f-863b-c8c1-aa82306a1ff4), you will see the only pre-req is that you are running SQL Server 2019.  No mention of needing CU2 or any KB or anything - just need to install the CU.

     

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • May 30, 2022 at 11:49 pm

    #4041767

    Hi thanks for your response

    There is a security update released for 2019

    Check this link

    https://support.microsoft.com/en-us/topic/kb4583458-description-of-the-security-update-for-sql-server-2019-gdr-january-12-2021-65859e33-296d-0b7d-5e13-69bbb6fb6974

    Also what about the previous versions before 2019 , I need to install security updates for those, can I just install the latest

  • May 30, 2022 at 11:56 pm

    #4041768

    Now that lists it as a security update but if you actually go to the download page, it is a GDR download which goes back to my previous reply.

    As for previous versions, I think it depends how far back you are going. I think that 2008 r2 and earlier didn't follow this model but if you are patching those, if recommend upgrading to at least 2017 if not 2019... Pretty sure 2012 and newer follow this model.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • May 31, 2022 at 12:02 am

    #4041769

    Hi Brian

    I have to only apply security updates .

    My versions are between 2012 and 2019

    I follow this tenable releases, now do i need to apply all previous updates before Jan 2021 say for the versions before 2019 or applying the latest is sufficient

  • July 27, 2022 at 1:46 pm

    #4068942

    I have a quick questions

    If I installed Cumulative Update 16 for SQL Server 2019 and then installed GDR 16 for SQL Server 2019 - will I be able to install the next Cumulative Update 17 without issues when it comes out?

    Any feedback is appreciated.

    Jeff

  • July 27, 2022 at 6:13 pm

    #4069055

    jayoub wrote:

    I have a quick questions

    If I installed Cumulative Update 16 for SQL Server 2019 and then installed GDR 16 for SQL Server 2019 - will I be able to install the next Cumulative Update 17 without issues when it comes out?

    Any feedback is appreciated.

    Yes.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 27, 2022 at 7:28 pm

    #4069093

    OK thank you.

    Jeff

  • July 28, 2022 at 8:21 am

    This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply