Post reply

ReportServerTempdb

  • February 26, 2009 at 11:35 am

    #155340

    Do we need to take the backups for ReportserverTempdb or can we omit as tempdb?

  • February 26, 2009 at 11:58 am

    #950754

    I believe the ReportServer TempDB is a "scratch" db and shouldn't need to be parrt of your backups.

  • February 26, 2009 at 12:00 pm

    #950755

    I believe the ReportServer TempDB is a "scratch" db and shouldn't need to be parrt of your backups

    That is not correct because when you move the ReportServerDB you also need ReportServerTempDB before running the relevant configurations. That is what Microsoft covered you need it in hardware failure which is rebuild.

    You back it up in simple recovery mode because if you have to rebuild or move SSRS to new server your new server needs both databases loaded into the Master before the relational engine can start SSRS. Check below for the guideline from Microsoft.

    http://msdn.microsoft.com/en-us/library/ms155814.aspx

    Kind regards,
    Gift Peddie

  • February 27, 2009 at 9:46 am

    #951270

    Oops, sorry for the misinformation.

    I assumed becasue the tables were consistently empty it was only used as needed.

    Thanks for the link to the article.

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

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