Reporting Services Disaster Recovery/Failover

• AVB

  SSChampion

  Points: 11418

  More actions

  September 28, 2010 at 7:50 am

  #238908

  I know there is a Reporting Services forum but I figured I get a better response in this one.

  Reporting services for us is an important part of our business so I'd like to be able to failover pretty quickly. We will have two DB servers mirrored and two NLB webservers.

  I was reading about Reporting Services Scale-Out Deployment but it doesn't apply to Standard.

  Does anyone have any feedback/suggestions on how they are handling failover for Reporting Services using SQL Standard 2008?

  TIA.

• DNA_DBA

  SSCrazy Eights

  Points: 9168

  More actions

  October 5, 2010 at 9:12 am

  #1231807

  I've not tried this and don't know if it works for 2008 but this describes how you can do DR with Reporting Services 2005:

  http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69699