Home Forums SQL Server 7,2000 Administration Shrinking Tempdb RE: Shrinking Tempdb
SQLBill
SSC Guru
Points: 51440
More actions
December 17, 2003 at 10:14 am
#486738
An easy way to 'shrink' the tempdb is to stop and restart the services when you are done with all your transactions. This will cause tempdb to be rebuilt based on the model database.
-SQLBill