sql server2008清理日志信息

USE [master]  

GO  

ALTER DATABASE CNMobile SET RECOVERY SIMPLE WITH NO_WAIT  

GO  

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

GO  

USE CNMobile   

GO  

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

GO  

USE [master]  

GO  

ALTER DATABASE CNMobile SET RECOVERY FULL WITH NO_WAIT  

GO  

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

GO