清ＭＳＳＱＬ日志

USE [master]  

GO  

ALTER DATABASE ASPState SET RECOVERY SIMPLE WITH NO_WAIT 

GO  

ALTER DATABASE ASPState SET RECOVERY SIMPLE  

GO  

USE ASPState 

GO  

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

GO  

USE [master]  

GO  

ALTER DATABASE ASPState SET RECOVERY FULL WITH NO_WAIT 

GO  

ALTER DATABASE ASPState SET RECOVERY FULL  

GO