USE [master]标签:SET,RECOVERY,SQL2008R2,数据库,BASE5,GO,日志,ALTER,FE From: https://blog.51cto.com/u_16000165/6113765
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