SQLServer2008R2 日志清理任务

wbv123

USE [master]
GO
ALTER DATABASE hydee SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE hydee SET RECOVERY SIMPLE –简单模式
GO
USE hydee
go
declare @name varchar(100)

select top 1 @name = name from sysfiles where status = 1048642

DBCC SHRINKFILE (@name , 11, TRUNCATEONLY)
GO
USE [master]
GO

ALTER DATABASE hydee SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE hydee SET RECOVERY FULL –还原为完全模式