For a great guide on SQL Server Reporting Services Disaster Recovery – check out our awesome case study. The case study is applicable to SQL Server 2008 R2 and mostly prevalent for SQL Server 2012 Reporting Services.
Authors: Ayad Shammout & Denny Lee
Technical Reviewers: Lukasz Pawlowski, Sanjay Mishra, Prem Mehra, Michael Thomassy, Lindsey Allen, Burzin Patel, Andy Wu, Thomas Kejser, Carl Rabeler, Quoc Bui
Applies to: SQL Server 2005, SQL Server 2008
Introduction
There are many ways to perform disaster recovery with Microsoft SQL Server Reporting Services (SSRS). Based upon customer experience and internal testing, this technical note provides guidance around best practices to design and manage robust end-to-end disaster recovery (DR). This DR method will involve both automatic and manual failover in the form of content switches, SQL Server failover clustering, and database mirroring. This case study focuses on the lessons learned from CareGroup Healthcare System.
Environment Setup
Figure 1 shows a basic disaster recovery scenario. The left side (in green) represents the primary data center, while the right side (in orange) represents the disaster recovery (DR)site. In general…
View original post 2,149 more words
Denny Lee 