|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
SELECT rs.recovery, bs.server_name as source_server, @@SERVERNAME as destination_server, [bs].[backup_start_date], [bs].[backup_finish_date], [bs].[database_name] as [source_database_name], [rs].[restore_date], rs.stop_at, rs.user_name, bs.user_name as backup_agent, bmf.physical_device_name, bs.backup_size 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.recovery=1 ORDER BY rs.recovery DESC, [rs].[restore_date] DESC |