也谈如何缩小SQL SERVER日志文件

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