Clear DB Log File in SQL Server

I am looking for a tsql or query which will clear the transaction log file/

Thanks in ad开发者_如何学运维vance.

---

try:

DUMP TRANSACTION [database_name] WITH NO_LOG

---

' execute with admin priveleges

BACKUP LOG db_name WITH NO_LOG

GO

DBCC SHRINKDATABASE( db_name, 0)

GO