[MSSQL] Database Last BackupDate

[MSSQL] Database Last BackupDate

 

- 데이터베이스 최종 백업일 가져오기

- MSDB.DBO.backupset

SELECT A.name DB명, CASE WHEN MAX(B.backup_finish_date) is NULL THEN 'No Backup' ELSE CONVERT(VARCHAR(100),MAX(B.backup_finish_date)) END AS 최종백업일 FROM SYS.DATABASES A LEFT JOIN MSDB.DBO.backupset B ON A.name = B.database_name AND B.TYPE = 'D' WHERE A.database_id NOT IN (2) GROUP BY A.name ORDER BY A.name