(转)SQL 日志太大,脚本清除 

USE [master]  

GO  

ALTER DATABASE mydatabase SET RECOVERY SIMPLE WITH NO_WAIT  

GO  

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

GO  

USE mydatabase

GO  

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

GO  

USE [master]  

GO  

ALTER DATABASE mydatabase SET RECOVERY FULL WITH NO_WAIT  

GO  

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

GO

 

posted @ 2012-10-22 10:37  jungil  阅读(123)  评论(0)  编辑  收藏  举报