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