MS SQL Log清除

ALTER DATABASE WT_EXP
SET RECOVERY SIMPLE
GO
ALTER DATABASE WT_EXP
SET RECOVERY FULL
GO

--BACKUP LOG [資料庫名稱] WITH NO_LOG
DBCC SHRINKDATABASE ([資料庫名稱], 10)

或是藉由SSMS把DB log level更改後shirnk也可