to shrink the tempDB

[maswien]

My question is, if for some reason we can't always restart SQL Server and the size of tempdb is too big, what is the best way to shrink it?

Thanks!

 

[SQLDenis]

DBCC SHRINKFILE

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[mrdenny]

Or DBCC ShrinkDatabase.

In addition to shrinking the file you will want to find out why it is getting larger. If it is growing regularly (do to maintaince plans or large daily/weekly bulk updates, etc that shrinking it won't do anything besides place un-needed additional load on the disks.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com