SQL Server Performance Forum – Threads Archive
how do you shrink tempdbRebooting server did not work and dbcc shrinkfile made current size its minimum size and can’t reduce size on properties window
1)you can alter tempDB to specify new tempfiles, need a Server restart .later you can delete old files
2)you can restart server in minimal config and alter currect size of files Following link explain both of them ..
also I am not sure whether we can Shrink+truccate files to reduce the size .Anyone have any idea?
go — this command shrinks the primary data file
dbcc shrinkfile (tempdev, ‘target size in MB’)
go — this command shrinks the log file
dbcc shrinkfile (templog, ‘target size in MB’)
go For details, please refer to:
http://support.microsoft.com/default.aspx/kb/307487 Jon M
KBAhttp://support.microsoft.com/default.aspx/kb/307487 to followup.
Oops, missed Jon’s post reference.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.