We have two farms, one DR and LIVE. In Live we have an SSRS box, and in DR we have an SSRS box. In a scenario where the live farm dies then obviously the second farm picks it up, however in the scenario where just the SSRS box dies what are the options?
- Can I just add the DR SSRS box (running same version as SharePoint) into the live farm? Can it be connected to two farms? Does the box know it is a SharePoint box other than the binaries being installed on it? Obviously I would then just reconfigure pointing it to the live databases.
- As above / but first remove it from DR? Is this really needed? On both live and DR SSRS servers, no SharePoint services run. Just the native SSRS service. Again, I think this would only be required if the server itself knows "I belong to this farm".
- Install SSRS in SharePoint integrated mode onto another box in the live farm as this already belongs to the live farm? configuring it to use existing live databases.
What does the option "Add a Report Server to the Integration" option actually do? Can only servers that have been added to the farm be added here? It is free text! Just wondered what direct action/config takes place on the SSRS server which would I guess enable or prevent the above options.
Thanks for advice/opinions