Advice needed on a simple DR solution for SQL Server and SSRS in SharePoint Integrated Mode
Hi, If anyone can provide some guidance then it would be greatly appreciated: Technologies involved: SQL Server 2008 R2 (Enterprise) and SharePoint 2010 (Enterprise) Topology: Server A (active) - Databases (SQL BI DB, Business Objects DB, SharePoint DBs, Report Server DBs, PerformancePoint DB), SSAS, SSIS, SSRS Report Server (in SIM)Server B (standby) - The idea is to use mirroring to create equal copies of all the Databases (SQL BI DB, Business Objects DB, SharePoint DBs, Report Server DBs, PerformancePoint DB)Server 1 (active) - SharePoint with SSRS add-onServer 2 (standby) - a similar installation and configuration as Server 1 Part of the solution: all the databases will be mirrored from A to B, and SharePoint on 1 (and indeed on 2) will be configured so that In SharePoint Server 2010 the ADO.NET connection object in case of non-connection to A will attempt the secondary connection string to B. My question relates to SSRS: I assume the SSRS DB and TempDB can be mirrored as the other DB's, but how is the integration between SharePoint and the new Report Server (B) handled if A fails? I am assuming this is done from the new Report Server configuration on B, if so what is best practice and can it be automated or is the configuration so trivial that manual intervention is very quick? And Secondly, how is SharePoint now made aware that B and no Longer A is the Report Sever for the RDL's stored in SharePoint?
April 15th, 2012 10:07am
You can check our whitepaper Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint Integrated Modehttp://msdn.microsoft.com/en-us/jj856260 Jaime - http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights
November 28th, 2012 12:43pm