SQL 2008 删除日志文件

--- SQL 2008 删除日志文件

USE [master]

GO

ALTER DATABASE FlowmanDB SET RECOVERY SIMPLE WITH NO_WAIT

GO

ALTER DATABASE FlowmanDB SET RECOVERY SIMPLE --简单模式

GO

USE FlowmanDB 

GO

DBCC SHRINKFILE (N'FlowmanDB_Log' , 11, TRUNCATEONLY)

GO

USE [master]

GO

ALTER DATABASE FlowmanDB SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE FlowmanDB SET RECOVERY FULL --还原为完全模式

GO