Reportservertempdb log file shrink

YvesR YvesR 5, 6 6 gold badges 41 41 silver badges 67 67 bronze badges. I have the space. I am more concerned about know why this has happened and what it means. You users uses subscriptions? If so they create reports time based and store them all without removing older ones?

That can cause the grow of the database. Thanks for that. Just queried the Subscriptions table and no subscriptions -- but good to know. In the database there are also auto-grow and shrink options. Is it possible that you auto grow but not shrink? Can you tell how exactly you did it? Sign up or log in Sign up using Google. Oreo 1, 7 7 silver badges 20 20 bronze badges. Navaneet Navaneet 5 5 gold badges 12 12 silver badges 23 23 bronze badges.

Add a comment. Active Oldest Votes. Here is the answer to my own question. Improve this answer. I had the same problem and used this to see that there was an active transaction in the db. As soon as the transaction completed the shrink worked just fine. Community Bot 1. Cougar Cougar 1, 1 1 gold badge 13 13 silver badges 29 29 bronze badges. But problem i encountered is different.

Please see my answer below — Navaneet. Glad to hear you got it figured out, thanks for the update! Remus Rusanu Remus Rusanu I think you are doing something wrong. If you take backup of log properly then unused log should be truncated. The commands given in my question may help you to solve the problem.

I approve this, same happen for me just now - only after second log backup it allowed me to perform shrink — ujeenator. Hope this helps. Toni Kostelac Toni Kostelac 4 4 bronze badges. Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed. ConformToPageReader matches no exports.

Did you miss a module reference? IBM Watson assistant — Live web chat integration. Golang and that strange asterisk and ampersant. Artificial Intelligence prepping data — Back to basic part 1. PaaS taking over the world! Setting up Ubuntu How to use Fusion Tables in your Android app. Edit files quickly with Vim on Windows. WordPress Di Blog Theme. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Learn more. Report Server tempdb's chunk data table is growing very large on daily basis Ask Question. Asked 3 years, 11 months ago. Active 3 years, 11 months ago. Viewed 2k times. Improve this question. Did you schedule any job for purge chuck data?