April 26, 2010 at 2:47 pm
My company is developing a Business Intelligence application to be deployed on our customers' servers under SQL 2005. ReportServerTempDB has a recovery model of Simple.
My question: Is there any reason to be concerned about ReportServerTempDB growing too large even though the recovery model is Simple?
Some time ago I read about periodically deleting from tables within that database as part of database maintenance. Would that really be necessary?
Thanks!
April 28, 2010 at 12:28 am
Hi,
ReportServerTempDB is used as session/caching repository...I feel that once the report is deployed and guaranteed there is no harm in deleting the "Not required" session data...though one might need to maintain a record of cached snaphots if the demand requires.
Hope this helps.
Raunak J
April 28, 2010 at 7:29 am
That does help, thanks... but not being very familiar with Reporting Services, from which table(s) should I delete data?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply