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

该脚本支持