restore history

use msdb
go
select top 20 *from restorehistory



select restore_date,destination_database_name,backup_start_date,backup_finish_date,physical_device_name
from restorehistory r inner join backupset b
on r.backup_set_id=b.backup_set_id
inner join backupmediafamily f
on b.media_set_id=f.media_set_id
and destination_database_name='abc'
order by restore_date desc