Easy with Simple Recovery DBCC SHRINKFILE (“_Log”, 1); GO otherwise USE AdventureWorks2008R2; GO — Truncate the log by changing the database recovery model to SIMP…