SqlServer清理日志

--压缩日志1
ALTER DATABASE 数据库名 SET RECOVERY SIMPLE
DBCC SHRINKFILE (数据库名_Log,0, TRUNCATEONLY)
ALTER DATABASE 数据库名 SET RECOVERY FULL

--压缩日志2
ALTER DATABASE [数据库名] SET RECOVERY SIMPLE WITH NO_WAIT 
GO
--设置数据库恢复模式为简单
ALTER DATABASE [数据库名] SET RECOVERY SIMPLE;
GO
--收缩日志文件
DBCC SHRINKFILE (数据库名_log, 11, TRUNCATEONLY);
GO
ALTER DATABASE [数据库名] SET RECOVERY FULL WITH NO_WAIT 
GO 
--恢复数据库还原模式为完整
ALTER DATABASE [数据库名] SET RECOVERY FULL