tempdb is large
Posted on 2006-11-08
I have the mdf of tempdb at 33 gig todays
how do i regain back the space..
I did shrink on the mdf but i see all the free space.
Do i do this..
Truncate free space from the end of the file
Can i do whilst activity
Should i set up a job to do it
dbcc shrinkfile (tempdev, '1000)
-- this command shrinks the primary data file
dbcc shrinkfile (templog, '100)