August 26, 2014 at 9:17 am
Here's the scenario:
Server1 databases:
RPT
REPORTS
CM
APPS
ReportServer
ReportServerTempDB
Server2 databases:
CRM
SES
Server3 databases:
ReportServer
ReportServerTempDB
1. Server3 handles SSRS for Server2
2. Server3 is about to be de-commissioned
I've copied SSRS databases from one server to another, including the key trickiness, but the talk around here is:
Can we copy the data from the Server3 SSRS databases into the existing Server1 SSRS databases?
My initial thoughts are no, because of the encryption key. Install SSRS on Server2 you say? Apparently I can't do an after-the-fact SSRS install because it's clustered.
August 26, 2014 at 9:50 am
Someone may disagree,
but Don't think you can merge server1 Report server databases with server 3 rs dbs.
why not create another ReportServerDB and ReportServerTempDB on Server1 with different names and use this for Server2.
see this link: http://stackoverflow.com/questions/12619436/moving-and-merging-reporting-server-instances
the worst case deploy manually these server 3 ssrs reports and reconfigure to point to Server 1.
August 26, 2014 at 7:58 pm
You could migrate your Server3 SSRS to be hosted / run on Server1 (presuming it's not clustered.)
Install a new instance of SSRS, do NOT set up the databases.
Backup the encryption key on Server3, then stop SSRS on Server3, detach the databases and copy them to Server1 (rename them in the process.)
Attach them, restore the encryption key from Server3 to your new instance, then point it at the DBs.
Even better, if it's all the same version of SSRS / SQL (might require Enterprise) you can set it up as a "scale-oout" deployment by pointing Server3 to the DBs on Server1. Makes testing a bit easier (heck, move the DBs and re-point Server3 first, verify that works, then do the scale-out trick to bring Server1 into the game.)
August 26, 2014 at 9:13 pm
Just to clarify: SSRS is not cluster aware so it would be treated as a standalone installation. It will not failover to any other node within your cluster. You would have to use the scale-out deployment model with SSRS to get any high availability.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply