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 6, 2012 12:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 1, 2014 2:47 AM
Points: 152, Visits: 197
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 6, 2012 1:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:38 AM
Points: 6,416, Visits: 13,797
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