Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ReportServer mirror Expand / Collapse
Author
Message
Posted Tuesday, November 06, 2012 12:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 4:41 AM
Points: 99, Visits: 129
Hi,
The sql server has ReportServer and ReportServerTempDB databases as a result of having SSRS on the sql server.
Question:
Can the ReportServerTempDB database be mirrored onto the DR server?
Thanks
Post #1381415
Posted Tuesday, November 06, 2012 1:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 5,204, Visits: 11,165
arkiboys (11/6/2012)
Can the ReportServerTempDB database be mirrored onto the DR server?
Thanks

Why are you considering mirroring on these databases?
Use scale out deployments and clustered instances of SQL Server to provide HA for SSRS instances.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1381435
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse