May 31, 2011 at 10:48 am
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.
May 31, 2011 at 10:54 am
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
May 31, 2011 at 12:26 pm
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