--压缩日志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