MS SQL Server: Log Backup LSN Mismatch
Thank you very much! You got me to the right track! The information in my table above was taken from the backup files.
Following SQL statement
SELECT 
    name, description, user_name, backup_start_date, backup_finish_date, type, first_lsn, last_lsn, checkpoint_lsn, database_backup_lsn
FROM
    msdb.dbo.backupset 
WHERE
     msdb.dbo.backupset.database_name IN (SELECT [name] FROM master.dbo.sysdatabases)
    AND msdb.dbo.backupset.database_name LIKE 'db_name'
    AND msdb.dbo.backupset.backup_start_date BETWEEN '2021-01-13 20:00:00.000' AND '2021-01-14 20:00:00.000'
ORDER BY backup_start_date

shows that the backup solution takes a unnecessary full backup (what is not the problem).
The problem is a log backup taken by a other user. Thats the file I don't have. Wired... but we are able to solve it with the information.




name
description
user_name
backup_start_date
backup_finish_date
type
first_lsn
last_lsn
checkpoint_lsn
database_backup_lsn




NULL
NULL
sql-server
2021-01-12 20:30:02.000
2021-01-12 20:30:04.000
D
171000001698500037
171000001700400001
171000001698500037
170000001098100037


NULL
NULL
sql-server
2021-01-12 20:48:00.000
2021-01-12 20:48:00.000
L
171000001696100001
171000001701900001
171000001698500037
171000001698500037


NULL
NULL
sql-server
2021-01-12 21:12:00.000
2021-01-12 21:12:00.000
L
171000001701900001
171000001715000001
171000001702100002
171000001698500037


NULL
NULL
sql-server
2021-01-12 21:36:00.000
2021-01-12 21:36:00.000
L
171000001715000001
171000001740600001
171000001715200002
171000001698500037


NULL
NULL
sql-server
2021-01-12 22:00:01.000
2021-01-12 22:00:01.000
L
171000001740600001
171000001748500001
171000001740800002
171000001698500037


NULL
NULL
sql-server
2021-01-12 22:24:00.000
2021-01-12 22:24:00.000
L
171000001748500001
171000001751100001
171000001748700002
171000001698500037


NULL
NULL
sql-server
2021-01-12 22:48:00.000
2021-01-12 22:48:00.000
L
171000001751100001
171000001753400001
171000001751300002
171000001698500037


NULL
NULL
sql-server
2021-01-12 23:12:00.000
2021-01-12 23:12:00.000
L
171000001753400001
171000001755700001
171000001753600002
171000001698500037


NULL
NULL
sql-server
2021-01-12 23:36:00.000
2021-01-12 23:36:00.000
L
171000001755700001
171000001756300001
171000001756100002
171000001698500037


NULL
NULL
sql-server
2021-01-13 00:00:00.000
2021-01-13 00:00:00.000
L
171000001756300001
171000001756700001
171000001756500002
171000001698500037


NULL
NULL
sql-server
2021-01-13 00:24:00.000
2021-01-13 00:24:00.000
L
171000001756700001
171000001757100001
171000001756900002
171000001698500037


NULL
NULL
sql-server
2021-01-13 00:48:00.000
2021-01-13 00:48:00.000
L
171000001757100001
171000001757500001
171000001757300002
171000001698500037


NULL
NULL
sql-server
2021-01-13 01:12:00.000
2021-01-13 01:12:00.000
L
171000001757500001
171000001757900001
171000001757700002
171000001698500037


NULL
NULL
sql-server
2021-01-13 01:36:01.000
2021-01-13 01:36:01.000
L
171000001757900001
171000001758300001
171000001758100002
171000001698500037


NULL
NULL
sql-server
2021-01-13 02:00:00.000
2021-01-13 02:00:00.000
L
171000001758300001
171000001758700001
171000001758500002
171000001698500037


NULL
NULL
sql-server
2021-01-13 02:24:00.000
2021-01-13 02:24:00.000
L
171000001758700001
171000001799800001
171000001758900002
171000001698500037


Veeam Backup &amp; Replication
Image-level backup
NT AUTHORITY\SYSTEM
2021-01-13 02:33:24.000
2021-01-13 02:33:37.000
D
171000001807500037
171000001809300001
171000001807500037
171000001698500037


NULL
NULL
sql-server
2021-01-13 02:48:01.000
2021-01-13 02:48:01.000
L
171000001799800001
171000001810300001
171000001807500037
171000001807500037


NULL
NULL
sql-server
2021-01-13 03:12:00.000
2021-01-13 03:12:01.000
L
171000001810300001
171000001947400001
171000001810500002
171000001807500037


NULL
NULL
sql-server
2021-01-13 03:36:00.000
2021-01-13 03:36:00.000
L
171000001947400001
171000001958500001
171000001947600002
171000001807500037


NULL
NULL
sql-server
2021-01-13 04:00:00.000
2021-01-13 04:00:00.000
L
171000001958500001
171000001960300001
171000001959000002
171000001807500037


NULL
NULL
sql-server
2021-01-13 04:24:00.000
2021-01-13 04:24:00.000
L
171000001960300001
171000001961400001
171000001960500002
171000001807500037


NULL
NULL
admin
2021-01-13 04:35:46.000
2021-01-13 04:35:46.000
L
171000001961400001
171000001962000001
171000001961600002
171000001807500037


NULL
NULL
sql-server
2021-01-13 04:48:01.000
2021-01-13 04:48:01.000
L
171000001962000001
171000001963800001
171000001962200002
171000001807500037


NULL
NULL
sql-server
2021-01-13 05:12:00.000
2021-01-13 05:12:00.000
L
171000001963800001
171000001964200001
171000001964000002
171000001807500037




Thank you very much. You helped me to nail down the issue.
Best
Frederik