Blog Archives
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
select server_name,
backupset.database_name,
backupset.backup_start_date,
backupset.backup_finish_date,
backupset.backup_size,
backupmediafamily.physical_device_name
from msdb.dbo.backupset
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!
