Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
I have changed the DB to FULL recovery mode temporarily untill this log space is released back to the disk
Waste of time.
In simple recovery model, the log is marked reusable when a chackpoint occurs, if nothing else needs the log records. In full recovery, a log backup is needed in addition. Hence, by switching to full recovery all you've done is add more conditions that have to be satisfied before the log can be reused. Switch back to simple.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass