Sql Server清理日志

declare @dbName varchar(100);
set @dbName='数据库名';--数据库名
backup log @dbName with NO_LOG;
backup log @dbName with TRUNCATE_ONLY;
DBCC SHRINKDATABASE(@dbName);