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!

Design a site like this with WordPress.com
Get started