Today my dev server was out of space and I found a file called templog under program files\microsoft sql server is 41GB. I did some research and found it is because there is a deferred transaction in sql server database. After restarting the sql server service from sql management studio, that templog file is back to nothing.