Execute the code below to get a list of all backups taken on the specific database.

You need to restore the backups in sequence, starting with the full backup that has the same number in the column [first_lsn] that the sequential LOG backups has in the [database_backup_lsn] column.

SELECT database_name

, backup_finish_date

, type

, first_lsn

, database_backup_lsn

, physical_device_name

FROM msdb.dbo.backupset

INNER JOIN msdb.dbo.backupmediafamily

ON backupset.media_set_id = backupmediafamily.media_set_id

WHERE backup_finish_date IS NOT NULL

AND database_name = '{fill_in_your_dbname}'

ORDER BY database_name

, backup_finish_date