My database size is 300 Gb and tempdb has grown upto 110 Gb . When I restart SQL server - this space gets freed up
I want to free up my tempdb space without restarting SQL server . I tried the following -
backup log [tempdb] with truncate_only
DBCC SHRINKDATABASE ([tempdb], 10, TRUNCATEONLY)
but of no use !
Please help !
View Complete Post