backup – Run SQL Server BLOG

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

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

Revovery állapotba hozott adatbázisok listája:

Mentés időpontjával, mentett szerver nevével , adatbázis névvel, agent , dátum és méret listázással:

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