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