SET NOCOUNT ON DECLARE @LogicalFileName sysname, @MaxMinutes
INT, @NewSize INT
USE tablename -- 要操作的数据库名 SELECT
@LogicalFileName = ’tablename_log’, -- 日志文件名 @MaxMinutes = 10, -- Limit
on time allowed to wrap log. @NewSize = 1 --
你想设定的日志文件的大小(M)
-- Setup / initialize DECLARE @OriginalSize
int SELECT @OriginalSize = size FROM sysfiles WHERE name =
@LogicalFileName SELECT ’Original Size of ’ + db_name() + ’ LOG is ’ +
CONVERT(VARCHAR(30),@OriginalSize) + ’ 8K pages or ’ +
CONVERT(VARCHAR(30),(@OriginalSize*8/1024)) + ’MB’ FROM
sysfiles WHERE name = @LogicalFileName CREATE TABLE
DummyTrans (DummyColumn char (8000) not null)
DBCC SHRINKFILE (@LogicalFileName, @NewSize) EXEC
(@TruncLog) -- Wrap the log if necessary. WHILE @MaxMinutes >
DATEDIFF (mi, @StartTime, GETDATE()) -- time has not expired AND
@OriginalSize = (SELECT size FROM sysfiles WHERE name = @LogicalFileName)
AND (@OriginalSize * 8 /1024) > @NewSize BEGIN -- Outer
loop. SELECT @Counter = 0 WHILE ((@Counter < @OriginalSize / 16)
AND (@Counter < 50000)) BEGIN -- update INSERT DummyTrans
VALUES (’Fill Log’) DELETE DummyTrans SELECT @Counter = @Counter +
1 END EXEC (@TruncLog) END SELECT ’Final Size of ’ +
db_name() + ’ LOG is ’ + CONVERT(VARCHAR(30),size) + ’ 8K pages or ’ +
CONVERT(VARCHAR(30),(size*8/1024)) + ’MB’ FROM sysfiles WHERE
name = @LogicalFileName DROP TABLE DummyTrans SET NOCOUNT OFF
[Access]sql随机抽取记录 [Access]ASP&SQL让select查询结果随机排序的实现方法 [办公软件]在sybase中插入图片、PDF、文本文件 [办公软件]安装Sybase ASE [办公软件]linux指令大全(完整篇) [办公软件]Linux新手入门常用命令大全 [办公软件]在RedHat Linux 9里安装gaim0.80 [办公软件]浅谈Linux 下Java 1.5 汉字方块问题解决方法 [办公软件]Linux程序员必读：中文化与GB18030标准 [办公软件]linux指令大全
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
