found the issue guys. somehow the tempdb log file was set to the same path as the database logfile and this was the reason it is getting re-created everytime the...