You should never delete the ReportServerTempDB - RS will no longer work afterwards.
The RS windows service should automatically cleanup entries in the ReportServerTempDB after they are expired (e.g. sessions expire after 10 minutes).
If the ReportServerTempDB allocates a lot of disk space, but the database is actually almost empty, you can try to compact / shrink the database (through SQL Server Management Studio) to reduce its footprint on the hard disk.
-- Robert
sql
No comments:
Post a Comment