Sql Server 2008日志清理 

USE [master]
GO
ALTER DATABASE DBname SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE DBname SET RECOVERY SIMPLE
GO
USE DBname
GO
DBCC SHRINKFILE (N'DBname_log' , 11, TRUNCATEONLY) 
GO
USE [master]
GO
ALTER DATABASE DBname SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE DBname SET RECOVERY FULL
GO

 

posted @ 2016-11-08 09:58  尚荣伊翁  阅读(147)  评论(0)  编辑  收藏  举报