There are many ways to perform disaster recovery with Microsoft SQL Server Reporting Services (SSRS).
If the primary data center RSDB SQL Server cluster goes offline, the disaster recovery solution is to manually fail over to the RSDB on the disaster recovery site to continue serving up reports. It is important to understand that the Reporting Services report jobs, schedules, and subscriptions will not be mirrored between the RSDB from the primary data center and the disaster recovery site. Note that logins created on the primary site may not be replicated to the disaster recovery site. For a great guide on SQL Server Reporting Services Disaster Recovery – check out our awesome case study. 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).
For the CareGroup Healthcare environment, the mirrored RSDB instance is named Montreal\sql4 and is a SQL Server cluster using SQL Server 2008 Enterprise.
This DR method will involve both automatic and manual failover in the form of content switches, SQL Server failover clustering, and database mirroring. Boston in this case), the SQL Server clusters for the primary data center and the disaster recovery site have the same name (more on this later).
For more information, see How to transfer logins and passwords between instances of SQL Server. Your situation may be different, but this technical note should provide you with the basic framework for Reporting Services disaster recovery. By configuring the primary data center and disaster recovery site RSDBs with identical instance names (recall that both instances are named sql4 but that they are in different domains), the manual failover is simplified because the Reporting Services servers will connect to an identically named instance of the RSDB (different domain, but same name).


The disaster recovery site should closely duplicate the primary data center Reporting Services environment.
To ensure connectivity from the clients to the primary data center and the disaster recovery site, a common technique is to use a content switch to load-balance traffic within the individual sites as well as between the global sites. For the CareGroup Healthcare environment, the primary RSDB instance within the primary data center is named Boston\sql4 and is a SQL Server cluster using SQL Server 2008 Enterprise, with the content switch pointing to the alias sql4. To ensure that the RSDB within the disaster recovery site is up-to-date, a common technique is to use asynchronous database mirroring. 2) Copy the backups over to the disaster recovery site, restoring each Reporting Services database in no-recovery mode.
In this scenario where the Reporting Services servers within the primary data center go offline, the hardware content switch will detect a network connectivity issue and automatically fail over to the disaster recovery site. If the entire primary data center goes offline for either a planned or unplanned outage, the content switch will automatically fail over to the Reporting Services farm in the disaster recovery site, but you will need to perform a manual failover to ensure that the Reporting Services servers can connect to the copy of the RSDB in the disaster recovery site. 1) The content switch will perform the task of suspending the primary IP addresses and activating the DR site IP addresses so that all connections will be redirected to the disaster recovery site. With these guidelines, you can prepare your Reporting Services environment for disaster recovery scenarios.
The left side (in green) represents the primary data center, while the right side (in orange) represents the disaster recovery (DR) site.
While most of the information here is applicable to these databases (such as data marts, operational data stores, transactional systems, and data warehouses), they have their own disaster recovery requirements and procedures that should be separate from the reporting infrastructure.
As well, there is direct fiber network connectivity between the primary data center and the disaster recovery site to ensure minimal latencies for any communication between the two centers.


For more information about how to best configure a SQL Server clustering environment, see SQL Server 2008 Failover Clustering.
For the CareGroup Healthcare environment, the mirrored RSDB instance is named Montreal\sql4 and is a SQL Server cluster using SQL Server 2008 Enterprise.
But note that this is a manual failover process, which requires manual configuration of the Reporting Services servers in the Reporting Services farm to point to the RSDB instance within the disaster recovery site. This occurs because SQL Server Agent jobs are stored in the msdb database, which is not mirrored. The key here is that you will need to use a combination of hardware components, network connectivity, SQL Server database mirroring, and architecture to create a disaster recovery infrastructure to support an enterprise SQL Server Reporting Services environment. Note that the disaster recovery (in this example, Montreal) server is the one that is now active, so you will need to manually transfer the data from the DR site server back to the primary data center server (in this example, Montreal to Boston). Note that the disaster recovery (in this example, Montreal) server is the one that is now active, so you will need to manually transfer the data from the DR site server back to the primary data center server (in this example, Montreal to Boston). A common method to resolve this issue is to script all of these Reporting Services jobs in the primary site and then use these scripts to re-create them on the disaster recovery site (with the jobs disabled); activate these jobs only if the system fails over. If the primary site goes down for any reason, the content switch transparently redirects all client traffic to the disaster recovery set of Reporting Services servers.



Electromagnetic pulse generator schematic
Weather disasters in history
Baby emergency kit gift
Risk assessment cleaning company


Comments

  1. 12.11.2013 at 22:30:42


    Not saying you should not survival kit.

    Author: Juan_Gallardo
  2. 12.11.2013 at 17:43:38


    Point in packing up your survival gear into the many.

    Author: MAD_RACER
  3. 12.11.2013 at 20:51:23


    Always ready for anything you are going to want to make sure questions.

    Author: VersacE
  4. 12.11.2013 at 15:54:15


    As this demonstration states that each individual requirements a single gallon that has sql recovering from a disaster sold Iran each North.

    Author: 202
  5. 12.11.2013 at 16:51:21


    EMP, solar storms the principal energy program can be quite crucial. This can.

    Author: baby_girl