How to generate a list of backups made
You can use the following query to show what backups have been made and help to locate where the backup parts were stored:
SELECT [media_set_id]
,[family_sequence_number]
,[media_family_id]
,[media_count]
,[logical_device_name]
,[physical_device_name]
,[device_type]
,[physical_block_size]
,[mirror]
FROM [msdb].[dbo].[backupmediafamily]
This can be especially helpful to verify the “Media Count” for each backup (so you save all of the parts).
Revised: 2018-12-21
Copied!