TEMP DB remains huge

  • hi guys i need help with the size of my temp DB in my production instance. the initial size of my db was 8 GBS but due to a large transaction my DB grew to be 50 GBs. At this time, we are having space issues in this server, i researched several ways to shrink this DB but all the ways i have found end up with doing an instance restart. Is there any way to run the DBCC shrinkdatabase without doing the server restart? this is a production instance.

  • Microsoft says you really can't shrink tempdb online. You either need to restart, or put the server in single-user mode at the least.

    You've probably already seen this, but here's the reference on that: http://support.microsoft.com/kb/307487

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • i was afraid of that, thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply