To Know When Last Backup & Last Restore Completed

select user_name, backup_size, database_name, backup_start_date, backup_finish_date from msdb.dbo.backupset

msdb.dbo.restorehistory -- This will give complete information about the restoring databases and all.