select top 1 b.backup_finish_date
from msdb..backupset b
join msdb..restorehistory r on b.backup_set_id = r.backup_set_id
where r.destination_database_name = 'MyDb'
order by r.restore_date desc
Wednesday, February 20, 2008
Dive into msdb: BackupSet & RestoreHistory
Simple question today: can we find out how recent the backup is that has been used to restore our production copy?
0 comments:
Post a Comment