≪共通スクリプト｜Common Script｜Emdb≫:データベースの最近のバックアップの表示

--===========================================================================
-- 
SELECT D.name  AS DatabaseName,
FB.FullBackupTime,
LB.LogBackupTime
FROM master.sys.databases D 
INNER JOIN sys.database_mirroring dm 
on D.database_id=dm.database_id
AND (dm.mirroring_guid IS NULL OR dm.mirroring_role=1)
LEFT JOIN (
SELECT database_name AS DatabaseName, max(backup_finish_date)  AS FullBackupTime
FROM msdb.dbo.backupset B1
WHERE  B1.type='D'
GROUP BY database_name, [type]) AS FB ON D.name=FB.DatabaseName
LEFT JOIN (
SELECT database_name AS DatabaseName, max(backup_finish_date)  AS LogBackupTime
FROM msdb.dbo.backupset B1
WHERE  B1.type='L'
GROUP BY database_name, [type]) AS LB ON D.name=LB.DatabaseName
WHERE D.database_id>4
--============================================================================