Use the following Query:
|
1 2 3 4 5 6 7 8 9 |
SELECT d.name, d.recovery_model_desc, MAX(b.backup_finish_date) AS backup_finish_date FROM master.sys.databases d LEFT OUTER JOIN msdb..backupset b ON b.database_name = d.name AND b.type = 'L' GROUP BY d.name, d.recovery_model_desc ORDER BY backup_finish_date DESC |
It will output the following (where the backup_finish_date column is the last time the logs have been truncated):
