Thanks again Joy. The details about what is in the RS database is helpful. I will summarize my plan and ask a couple of final questions for the in-place upgrade.
A. I will backup all my database including both SSRS databases.
B. I will backup the SSRS encryption keys to a file and I noted all setting and values for all tabs in the SSRS configuration manager.
C. I will upgrade in-place my DBMS from 2016 to 2019 (do I use the checkbox and allow this upgrade to uninstall the existing SSRS at the same time?)
D. I will install the new SSRS download
E. I will restore both SSRS database and the encryption key.
My final questions are?
- Will I need the RSReportServer.config file or any of the config files I see on the current SSRS install in C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services. Should I backup and possible replace any of the files after the new SSRS installation.
- Do I use the checkbox and allow this upgrade to uninstall the existing SSRS at the same time as the DBMS upgrade, or do I uncheck this, and can the new SSRS install coexists with the original?
I will upload a few screen prints.