April 7, 2009 at 2:50 pm
Maybe I'm getting old - I have inherited a server that has TempDB set to 10,240K I have 16 procs and not enough space to make 15 additional f10,240k files.
Question how do I reduce the first tempdb.mdf to 512k? Shrinkfile can go below but the minute you restart SQL it recreated the first file at 10,240K.
John Zacharkan
April 7, 2009 at 3:51 pm
stunned -
dbcc shrinkfile (1, 1)
ALTER DATABASE tempdb MODIFY FILE
(NAME=N'tempdev' ,
SIZE = 128MB,
FILEGROWTH = 0)
Stop SQL
Start SQL
still 128mb that works.
John Zacharkan
April 7, 2009 at 3:57 pm
Tempdb is created from the model db which by default is 0.75MB. I don't see a way to shrink it to 512KB.
April 7, 2009 at 4:02 pm
yeah those were supposed to be mb i was just typing it out
John Zacharkan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply