Post reply

upgrade order of components

  • February 16, 2024 at 8:11 pm

    #4379910

    I am upgrade a SQL server 2019 instance, it has both DB engine, SSIS service , SSRS service in same server due to it only host a small application.

    Now I would like to upgrade it from 2019 to 2022 and CU11,  My question is about the order,

    My order is like this, simplified:

    1. upgrade DB engine and SSIS to 2022.   2. then apply CU11.   3. install 2022 SSRS and reconfigure it

    Or should I do 3 first, then 2.

    Or it does not matter.

    Thanks

  • February 17, 2024 at 9:10 pm

    #4380380

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

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

  • February 18, 2024 at 10:44 am

    #4380591

    the SQL2022 CU11 patch potentially covers SSRS and SSAS as well. as a result, I would recommend the following:

    1. if you use UNC paths for your backup directory, you must change it to a local directory
    2. i change mine from \\domainserver\SQLBackups to whatever is the data directory for the duration of the upgrade, then change it back.
    3. in place upgrade of SQL2019 to SQL2022
    4. install SSRS 2022
    5. Run the patch for CU11

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 18, 2024 at 12:01 pm

    #4380610

    but do investigate all performance issues with 2022 before upgrading - many reporting 20 to 40% slower queries.

Viewing 4 posts - 1 through 3 (of 3 total)

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