摘要：
如果SQL SERVER 日志过大，比如，达到了几十个G，想一次性收缩的，直接执行下面命令即可：USE DATABASENAME;GO– Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABASE DATABASENAMESET RECOVERY SIMPLE;GO– Shrink the truncated log file to 1 MB.DBCC SHRINKFILE (DATABASENAME_Log, 1);GO– Reset the database recovery model 阅读全文