SQL server query to empty the database transaction log file.

backup log [DB_NAME] with truncate_only;
go
DBCC SHRINKDATABASE ([DB_NAME], 10, TRUNCATEONLY);
go