• Hi Krishna,

    You must be aware that restarting the Sql Server services can free up all the space for tempdb, but this is not a solution for a very busy 24*7 Production Server.

    Can you check the recovery model that is set and the result of the below query for your temp db select name,log_reuse_wait,log_reuse_wait_desc from sys.databases where name like 'tempdb' ??