I need to empty an LDF file before sending to a colleague. How do I force SQL Server to truncate the log?
Solution:
ALTER DATABASE ExampleDB SET RECOVERY SIMPLE
DBCC SHRINKFILE('ExampleDB_log', 0, TRUNCATEONLY)
ALTER DATABASE ExampleDB SET RECOVERY FULL
From: What is the command to truncate a SQL Server log file? - Stack Overflow