-收缩日志
  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 on 2012-10-18 08:52  micenter  阅读(497)  评论(0编辑  收藏  举报