收缩SqlServer数据库日志语句

 

收缩SqlServer数据库日志SQL语句

USE[master]
ALTER DATABASE XXX SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE XXX SET RECOVERY SIMPLE
USE XXX
if EXISTS(SELECT * FROM SYS.tables where name = 'LogSize') begin drop table LogSize end
create table dbo.LogSize( dbname nvarchar(50) not null, logsize decimal(8, 2) not null, logused decimal(5, 2) not null, status int null)
insert into dbo.LogSize execute('dbcc sqlperf(logspace)')
DECLARE @LogSize INT; SELECT @LogSize = round(LogSize * 0.5, 0) FROM dbo.LogSize WHERE dbname = 'XXX'
DBCC SHRINKFILE(N'HZDT_log' , @LogSize, TRUNCATEONLY) DROP TABLE dbo.LogSize
USE[master]
ALTER DATABASE XXX SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE XXX SET RECOVERY FULL