Hi Gurus,

Thank you very much for all responses.

I have one more question:

If tempdb log is very big (occupy all drive space) and even after
shrinking also disk space is not reducing.
Without rebooting the Server can we handle this situation?



Thanks & Regards,
Vinay Thakur
SQL Server DBA

MS Sql Server LazyDBA home page