how do you shrink tempdb | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how do you shrink tempdb

Rebooting 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
or
2)you can restart server in minimal config and alter currect size of files Following link explain both of them ..
http://www.tkdinesh.com/faq/ans/tempdbshrink.html
also I am not sure whether we can Shrink+truccate files to reduce the size .Anyone have any idea?
use tempdb
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.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>