August 1, 2012 at 11:39 am
Hi All,
I have a question about the Report server database(ReportServerDB, ReportSerevrTempDB). I am moving databases from one server to the other. WHile I do that should I also move the Report server DBs too?? And when I install SSRS service does it automatically gets synched up with the restored Report servers.
What happens if I change the names of the Report server DBs?? Will they still work.
Thank you in advance
August 2, 2012 at 2:12 am
So this is going to be a new server for the engine and SSRS? If so make sure you take a backup of the reporting services encryption keys before you do anything, without them you wont be able to use the report databases on a different SSRS installation.
Once done, you can pretty much do what you want with them, you can rename them, just when you go through the SSRS configuration you point to the renamed database.
Once the new SSRS is configured restore the encryption keys and you should be good to go.
An alternative would be to use a tool called RSScriptor which will copy all the rdl's etc from your current SSRS server and allow you to restore them to another SSRS server, that is if you dont want to backup the keys and move the databases.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply