Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is it possible to mirror the SQL Server (2005 or 2008) Reporting Services databases (ReportServer, ReportServerTemp)? I have a web site that uses a database that is already mirrored, and it also makes use of the Reporting Services. I want to be able to failover the primary server to the mirror, and have the reporting component also failover. Has anybody done this? Any gotchas?

share|improve this question

4 Answers 4

up vote 2 down vote accepted

here is another reference link http://sqlcat.com/technicalnotes/archive/2009/10/23/sql-server-reporting-services-disaster-recovery-case-study.aspx

you can certainly mirror the db's, but SSRS needs a handful of other items to failover as well. so, while your data gets mirrored, you may have to manually failover some components.

share|improve this answer

Database mirroring isn't supported by SQL Reporting Services.

http://msdn.microsoft.com/en-us/library/bb510781%28SQL.90%29.aspx

share|improve this answer
    
It's not for SQL 2005, but it is for SQL 2008, and 2008 R2 –  Elijah W. Gagne Apr 24 '13 at 15:06

I run an async mirrored SSRS catalog and tempdb and in the SSRS config I use a DNS alias for the server name so that in order to move the catalog to the mirror server I update the DNS record, switch the mirror mode to sync and then manually fail the databases over. Automatic failover is not supported.

share|improve this answer

We integrated something like this:

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

But we used WMI alerts to determine failover, and didn't mirror ReportTempDB

Basically you mirror ReportDB, have the report service set up independently on each server, and then setting up the failover: stop the reporting services on the mirror server, and start it on the principal. However, if you're not using Enterprise, you can't use a scale-out solution (multiple reporting services connected to same DB), so the key piece is to clear the keys out of the ReportService database, and then run a tool to import the key for the current server. It works pretty well.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.