SET nocount on
declare @LogicalFileName sysname, @MaxMinutes int, @newsize int

use tempdb
select @LogicalFileName='tempdblog', @maxMinutes= 10, @NewSize=100

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)

declare @counter int, @starttime datetime, @truncLog varchar(255)
select @starttime = getdate(),@TruncLog='Backup LOG '+db_name()+' with truncate_only'

dbcc shrinkfile(@logicalfilename,@newsize)
exec (@TruncLog)

while @maxminutes>datediff(mi,@starttime,getdate())
and @originalsize=(select size from sysfiles where name=@logicalfilename)
and (@originalSize*8/1024)>@newsize
begin
select @counter=0
while ((@counter<@originalsize/16) and (@counter<50000))
begin
insert DummyTrans values ('FillLog')
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
print '*** Perform a full database backup ***'
set nocount off