SQL2008R2 截断日志否则无法收缩数据库

USE [master]
GO
ALTER DATABASE FE_BASE5 SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE FE_BASE5 SET RECOVERY SIMPLE
GO
USE FE_BASE5
GO
DBCC SHRINKFILE (N’FE_BASE5_log’ , 11, TRUNCATEONLY)

USE [master]
GO
ALTER DATABASE FE_BASE5 SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE FE_BASE5 SET RECOVERY FULL
GO