ReportServer mirror

• arkiboys

  Hall of Fame

  Points: 3958

  More actions

  November 6, 2012 at 12:36 am

  #270545

  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

• Perry Whittle

  SSC Guru

  Points: 233821

  More actions

  November 6, 2012 at 1:27 am

  #1556346

  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" 😉