September 12, 2003 at 10:47 am
My tempdb has grown to 43 GB and is only using 2 MB. How do I get it to release the unused allocation. I've tried shrink db with no change.
September 12, 2003 at 11:29 am
easiest way is to stop and restart SQL Server services.
-SQLBill
September 13, 2003 at 10:40 am
agreed.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 11:03 am
Thanks for the help, it worked, problem solved.
Hate to think where we'd be without SQL Server Central.
September 13, 2003 at 11:29 am
Thanks for the complement. Tell your friends!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply