A very handy SQL Script to check the last time database was restored.
This comes handy when you are trying to figure out when was the last database backup for was done so you can plan on the last backup file to restore from.
--Last Database Restore for a specific database
SELECT
[rs].[destination_database_name],
[rs].[restore_date],
[bs].[backup_start_date],
[bs].[backup_finish_date],
[bs].[database_name] as [source_database_name],
[bmf].[physical_device_name] as [backup_file_used_for_restore]
FROM msdb..restorehistory rs
INNER JOIN msdb..backupset bs ON [rs].[backup_set_id] = [bs].[backup_set_id]
INNER JOIN msdb..backupmediafamily bmf ON [bs].[media_set_id] = [bmf].[media_set_id]
where [rs].[destination_database_name] = '[db_name]'
ORDER BY [rs].[restore_date] DESC