The ReportServerTempDB.mdf file is getting bigger and I have limited space on disk; is there any way to clear or reduce the size of the ReportServerTempDB.mdf and ReportServerTempDB_log.LDF files. Thanks.
Hi all,
SQL 2005 Report server TempDB log file size is 5GB.How can I clear/Delete the log file.I am using win2003 with service pack 1. Here little info about my SQL server.
Microsoft SQL Server Management Studio9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer7.0.5730.11
Microsoft .NET Framework2.0.50727.42
Operating System5.2.3790
What are the precautions I need to take.Sorry I am not a DBA.Please advice.Thanks in advance
I have a db server that had served both my application data and reporting services. I have since installed a second db server to be the reporting services server; the primary box still stores the application data. I am keeping reporting services installed and set up on the primary box, since I would like it to act as a warm standby for the reporting services function.
However, the ReportServerTempDB on my primary box is still quite large. The ChunkData table is quite close to 10 gig. The CleanupCycleMinutes property is set to the default of 10. Clearly any data that might be in this table is far older than that.
Is there some recommended method of clearing this data? Can I just delete the rows or do a truncate on the table? I would prefer not to uninstall/reinstall reporting services, as this machine is actively serving my application data.
Thanks.
Hi SSRS Experts
We encounter the problem, that a reportservertempdb grows extremly large... the sessiondata and snapshotdata tables are about 10gb each at the moment and keep growing and growing...
The CleanupCycleMinutes Configuration is set to default=10. We are not taking snapshots of our reports.
Shouldnt those tables be cleaned up every 10minutes with this setting?
What can we do to stop this database growing? is truncating those tables on a weekly base a solution?
We are using SQL Server Reporting Services 2005 SP2 with Cumulative Hotfix Package 5 (Build 3215).
Thanks for your answers...
Kind Regards,
Roger
Hi all,
Is it possible to cleanup ReportServer DB and ReportServerTempDB by setting the time interval ? For example, I want data in these two dbs to be deleted automatically after 5 or 10 minutes. How can I do that because as new reports are added and executed data goes on increasing in very short time and hurts performance.
Thanks,
Prashant
My ReportServerTempDB is full regularly .I had to shirink the database on regular interval though i schedule for shirinking on 30 minutes.But as soon there is any exception due to scripting the log is full and my all report manaer throws error.
After shirinking the ReportServerTempDB the reports starts working fine.
Please Help me to remove this frequent error.
As we have heavy reports.and due to large space occupied by reportservertempdb.ldf we have to manually detach the ldf every time in few days..how can i programitically minimize the space generating in reportservertempdb.ldf..
Give me some tips that i sud take care of for this issue..
Hi All,
I need to shrink database of reportserverTempdb since this db takes i.e MDF file has 6.11 GB and LDF file has 35.GB. When i take backup of this db it is getting created more than 23 GB.
Can you please tell me how to reduce this size?
Thanks in advance,
Anand Rajagopal
Hi
There are some complex reports in my report server, so I want use scheduled snapshot to improve the performance. But I don't want the generation of snapshot effect other report. Is it possible I create another report server, and use the same reportservertempdb database but the reportserver database is different. Then I can configure the second server create the snapshot automatically. In other words, I want to configure 2 report server share the same snapshot or cache. Is it possible?
And another question is if I can configure the parameter value which will be used in snapshot generation.
Thanks and regards
I receive this message when I try to run any report. The reportserver and reportservertempdb databases were upgraded using backup/restore from SQL2000 to SQL2005 on a separate server which is running RS2005 . Please help. Thanks
View 1 Replies View Related