Post reply

Log shipping on SSRS ( ReportServerTempDB )

  • November 19, 2014 at 8:51 am

    #301307

    Hello all,

    In an SSRS database install along with a log shipping configuration towards a failover server, do we need to log ship the ReportServerTempDB DB also necessarily ?

    thx

  • November 19, 2014 at 10:36 am

    #1759578

    no it's a temporary workspace

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 19, 2014 at 11:03 am

    #1759588

    Perry Whittle (11/19/2014)

    no it's a temporary workspace

    What if we have to perform a switchover to the DR node and activate the ReportServer DB ( in NO RECOVERY MODE ) with no ReportServerTempDB ?

    Do we need to script this database TEMP manually and re-create it if we failover ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply