December 11, 2008 at 11:44 am
quick question.....
Do I need to backup the reportserver tempdb database? I would think the answer is no because after all it is a tempdb. Just wondering. Currently I am not backing it up.
Thank you.
December 11, 2008 at 2:15 pm
I do not believe so
If I recall correctly
ReportServerTempDB exists because it's used as temp table/db by the Report Server, especially snapshots
it doesn't use the native tempdb that's session-only
so there is no harm in losing ReportServerTempDB
December 12, 2008 at 2:08 am
although its only a work area I would still keep one backup on local disk just in case you need to recover for some reason. You never know, you may lose the disks.
thanks
SQL_EXPAT
December 15, 2008 at 2:42 am
You can back it up but the purpose would be for its structure rather than its data.
Here is a link to some guidelines, including some of the other backup considerations required such as encryption keys and report files.
James Howard
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply