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