Script para saber quais Restores foram executados e quando

Select A.destination_database_name, A.restore_date, B.backup_start_date, B.backup_finish_date, B.database_name as source_database_name, C.physical_device_name as backup_file_used_for_restore

From msdb..restorehistory A

INNER JOIN msdb..backupset B ON A.backup_set_id = B.backup_set_id

INNER JOIN msdb..backupmediafamily C ON B.media_set_id = C.media_set_id

Order by A.restore_date DESC