This post originated from an RSS feed registered with .NET Buzz by Richard Jonas. Original Post: Shrinking an SQL Server 2000 Transaction Log Feed Title: Richard Jonas Feed URL: http://feeds.feedburner.com/blogspot/ouNA Feed Description: Richard Jonas's blog about .NET, web development and agile methodologies. Latest .NET Buzz Posts Latest .NET Buzz Posts by Richard Jonas Latest Posts From Richard Jonas

use database_name
go
create table shrinkfile(
col1 int,
col2 char(2048)
)

dump tran database_name with no_log
dbcc shrinkfile(logical_name_of_log, 50, TRUNCATEONLY)
go


set nocount on
declare @i int
declare @limit int

select @i = 0
select @limit = 10000

while @i < @limit
begin
insert into shrinkfile values(@i, 'Shrink the log...')
select @i = @i + 1
end

drop table shrinkfile