SELECT r.destination_database_name , r.restore_Date, r.user_name , b.database_creation_date , b.backup_start_date , b.backup_finish_date , b.compatibility_level , b.database_name , b.server_name , b.machine_name , b.recovery_model, r.destination_database_name FROM [msdb].[dbo].[restorehistory] r JOIN [msdb].[dbo].backupset b ON r.backup_set_id = b.backup_set_id ORDER BY r.restore_date DESC