Sqlserver 压缩日志脚本

/* 压缩日志 */

USE [master]

ALTER DATABASE kmshop_run
SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE kmshop_run
SET RECOVERY SIMPLE --简单模式

GO

USE kmshop_run

DECLARE @logname VARCHAR(150)

SELECT @logname = NAME
FROM sys.database_files
WHERE NAME LIKE ‘%log‘

DBCC SHRINKFILE(@logname, 10, TRUNCATEONLY)

GO

USE [master]

ALTER DATABASE kmshop_run
SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE kmshop_run SET RECOVERY FULL --还原为完全模式

GO

Sqlserver 压缩日志脚本

原文：https://www.cnblogs.com/jay257248/p/11048274.html