-- create
CREATE database testDb1
go

ALTER DATABASE testDb1 SET RECOVERY FULL WITH NO_WAIT
GO

use testDb1
go

BACKUP DATABASE testDb1 
TO  DISK = N'D:\Datasets\testDb1.bak' 
WITH INIT,  NAME = N'testDb1-Полная копия testDb1', STATS = 5

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Create table LB1'))
create table LB1(
id int )
go

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Insert 5 and 8'))
insert into LB1
values(5), (8)

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Insert 7 and 10'))
insert into LB1
values(7), (10)

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Backup Log'))

BACKUP log testDb1 
TO  DISK = N'D:\Datasets\testDb1_log1.bak' 
WITH INIT,  NAME = N'Инкремент №1', STATS = 5

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Insert 9 and 12'))
insert into LB1
values(9), (12)

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Insert 11 and 14'))
insert into LB1
values(11), (14)

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Backup Log'))

BACKUP log testDb1 
TO  DISK = N'D:\Datasets\testDb1_log2.bak' 
WITH INIT,  NAME = N'Инкремент №2', STATS = 5

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Delete 5 and 8'))
insert into LB1
delete from LB1 where id in (5,8)

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Delete 7 and 10'))
delete from LB1 where id in (7,10)

waitfor delay '00:00:02'

print(concat(convert(varchar, getdate(), 127), '    Backup Log'))

BACKUP log testDb1 
TO  DISK = N'D:\Datasets\testDb1_log3.bak' 
WITH INIT,  NAME = N'Инкремент №3', STATS = 5

select * from LB1