That means that an earlier transaction log is required to maintain the transaction log sequence. Perhaps someone made a backup of the transaction log manually?
You could use the following query to find the missing file(s), and also when the backup was taken and by whom:
- Code: Select all
SELECT b.physical_device_name, a.user_name, a.backup_start_date
FROM msdb..backupset a
INNER JOIN msdb..backupmediafamily b on a.media_set_id = b.media_set_id
WHERE a.type = 'L'
AND a.database_name = '<your database name>'
AND a.first_lsn <= 7644000005259000001 AND a.last_lsn >= 7644000005259000001
Note that you have to fill in the database name in the above script.
If the missing files are SQL Server backup files, you'll need to restore them using Management Studio first, before using SQL Backup to restore the subsequent files. If the missing files are SQL Backup backup files, you could place them in the same directory with your existing SQL Backup files, and use SQL Backup to restore them all together.