Skip to content

SqlServer数据库单机模式下的日志收缩 ​

SQL
USE Test
GO
ALTER DATABASE Test SET RECOVERY SIMPLE WITH NO_WAIT
GO
--设为简单模式
ALTER DATABASE Test SET RECOVERY SIMPLE 
GO

USE Test
GO
DBCC SHRINKFILE (N'Test_log', 1, TRUNCATEONLY) 

GO
USE Test
GO
ALTER DATABASE Test SET RECOVERY FULL WITH NO_WAIT
GO
--还原为完全模式
ALTER DATABASE Test SET RECOVERY FULL 
GO