I noticed that my database log file has reached 160GBs. My database is in simple recovery mode and I used the following query to see if there are any waiting transactions.
SELECT d.name,d.log_reuse_wait,d.log_reuse_wait_desc FROM sys.databases d
log_reuse_wait 0 and
Why is my transaction log growing then?