запусти Sp c именем БД и все


CREATE proc sp_shrinklog
as
declare @dbname sysname, @i int
set nocount on
select @dbname = db_name()
checkpoint
exec('DBCC SHRINKFILE (2, 1, NOTRUNCATE)')
exec('DBCC SHRINKFILE (2, 1, TRUNCATEONLY)')
exec ('create table t1 (char1 char(4000))')
select @i = 0
while (@i < 1000)
begin
exec('insert t1 values (''a'')')
select @i = @i + 1
end
exec('drop table t1')
exec('BACKUP LOG ' + @dbname + ' WITH TRUNCATE_ONLY')
return 0
GO