...my own personal experience with SQL Server...
select top 1 b.backup_finish_datefrom msdb..backupset bjoin msdb..restorehistory r on b.backup_set_id = r.backup_set_idwhere r.destination_database_name = 'MyDb'order by r.restore_date desc
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
Post a Comment
No comments:
Post a Comment