Sql Server 2008日志清理

USE [master]
GO
ALTER DATABASE DBname SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE DBname SET RECOVERY SIMPLE
GO
USE DBname
GO
DBCC SHRINKFILE (N'DBname_log' , 11, TRUNCATEONLY) 
GO
USE [master]
GO
ALTER DATABASE DBname SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE DBname SET RECOVERY FULL
GO
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/shangrongyiweng/p/6041665.html