SQL Backup File location and date time
So, you want to see when you’ve backuped up what/where and when. Certainly something that’s worth keeping an eye on, but how do you find it? Here’s how
inner join msdb.dbo.backupmediafamily
on backupmediafamily.media_set_id = backupset.media_set_id
order by backupset.backup_finish_date desc
So, if you run your backups like I do (just to a named file and not so much media sets) you could use this to do a restore!