Post reply

Do we need to backup reportServerTempdb

  • November 22, 2011 at 12:53 pm

    #263371

    Hi,

    Do we need to backup reportServerTempdb? Is it supported? I know that we cannot backup tempdb and want to know any backup rules for reportServerTempdb?

    thanks

  • November 22, 2011 at 1:47 pm

    #1411793

    Need to....maybe not. Should you....might make recovery easier.

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

    The only reason to backup the reportservertempdb is to avoid having to recreate it if there is a hardware failure. In the event of hardware failure, it is not necessary to recover the data in reportservertempdb, but you do need the table structure. If you lose reportservertempdb, the only way to get it back is to recreate the report server database. If you recreate the reportservertempdb, it is important that it have the same name as the primary report server database.

  • November 23, 2011 at 3:36 am

    #1412034

    Not required, But we need to have to avoid missing table structure....in case of failures...recovery...so we will take backup


    - Pradyothana     http://www.msqlserver.com

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

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