USE [ADMIN]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP$BackupLog]    Script Date: 17.08.2021 16:26:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[BACKUP$BackupLog]
@dbname sysname, @path varchar(500), @exec int = 0
as
begin

Declare
@sql		nvarchar(4000),
@message	varchar(400),
@datepart	varchar(200),
@full_name	varchar(1000)

if db_id(@dbname) is null
	begin
		raiserror ('Database not found.', 16, 1)
		return -1
	end
	
if right(@path, 1) <> '\'
	set @path = @path + '\'

select @datepart = convert(varchar, getdate(), 112)

select @sql = 'md ' + @path + @datepart

exec master..xp_cmdshell @sql

select @path = @path + @datepart + '\'

select @datepart =  @dbname + '_tlog_' + convert(varchar, getdate(), 112) + '_' + 
case
	when  len(convert(varchar, datepart(hh, getdate()))) < 2 then '0' + convert(varchar, datepart(hh, getdate()))
	else convert(varchar, datepart(hh, getdate()))
end
+
case 
	when len(convert(varchar, datepart(mi, getdate()))) < 2 then '0' + convert(varchar, datepart(mi, getdate()))
	else convert(varchar, datepart(mi, getdate()))
end
+ '.BTL'

set @full_name = @path + @datepart

select @sql = 'backup log [' + @dbname + '] to disk=''' + @path + @datepart + ''''   

insert into [admin].dbo.LOG_BackUp ([Db_name],BackUpType,BackUpFolder,BackUpStart,Complite) values (@dbname,'LOG',@full_name,GETDATE(),0)
if @exec = 1
	exec master..sp_executesql @stmt = @sql
else
	print @sql
update [admin].dbo.LOG_BackUp set BackUpEnd=GETDATE(),Complite=1 where BackUpFolder=@full_name

end

DECLARE @db_name nvarchar(128),@path nvarchar(max),@sql nvarchar(max)
DECLARE vendor_cursor CURSOR FOR   
select [db_name],BackUpFolder from [GAMMA\SRVSQLNKC].[ADMIN].dbo.LOG_BackUp where [Db_name]='Checks' and BackUpType='LOG' and complite=0 order by id asc 
  
OPEN vendor_cursor  
  
FETCH NEXT FROM vendor_cursor   
INTO @db_name, @path  
  
WHILE @@FETCH_STATUS = 0  
BEGIN  
    select @db_name,@path
	set @sql='RESTORE LOG [Checks_og] FROM  DISK = N'''+@path+''' ,  NOUNLOAD,  STATS = 10'
	exec sp_executesql @sql
	update [GAMMA\SRVSQLNKC].[ADMIN].dbo.LOG_BackUp set complite=1 where BackUpFolder=@path
        -- Get the next vendor.  
    FETCH NEXT FROM vendor_cursor   
    INTO @db_name, @path  
END   
CLOSE vendor_cursor;  
DEALLOCATE vendor_cursor;