清理sqlserver2014的日志

ALTER DATABASE DATABASENAME  SET RECOVERY SIMPLE   
GO
USE DATABASENAME 
GO
DBCC SHRINKFILE (DATABASENAME_log , 11, TRUNCATEONLY) --收缩日志到11M，DATABASENAME_log为数据库日志文件的逻辑名称
GO
ALTER DATABASE DATABASENAME  SET RECOVERY FULL; 
GO