Last Backup/Restore date of database
If you want to know the last Backup/Restore date of database, use the following
--Last Backup date of database
--Method 1
In Management Studio,Expand database,Right Click on the database and click properties
Refer Last Batabase Backup which is availalbe under General
--Method 2
select
database_name,max(backup_finish_date) as backup_finish_date from msdb..backupset
where database_name='your_database'
group by database_name--Last Restore date of database
select
destination_database_name,max(restore_date) as restore_date from msdb..restorehistory
where destination_database_name='your_database'
group by destination_database_name