Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Saturday, April 30, 2016 1:59 AM
Points: 181, Visits: 242
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:26 AM
Points: 8,098, Visits: 16,276
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