Clear DB Log File in SQL Server

Question

Hi everyone,

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

Thanks in advance.

Answer 1

try:

DUMP TRANSACTION [database_name] WITH NO_LOG

Answer 2

' execute with admin priveleges

BACKUP LOG db_name WITH NO_LOG

GO

DBCC SHRINKDATABASE( db_name, 0)

GO