November 22, 2011 at 12:53 pm
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
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
Not required, But we need to have to avoid missing table structure....in case of failures...recovery...so we will take backup
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply