sanket kokane (10/31/2012)
you can restrict the tempdb log file size ,so that it will stop growing and log file will get reuse .and then you can try to shrink .
also restarting the sql server service can help you ...but I will never recommend for it 😉
restarting sql server will help and how about closing/droping all the temp objects after its use is over.
but restricting tempdb size might also cause the query related to tempdb to wait for resources incase other resource still want the tempdb space.
Regards
Durai Nagarajan