SQL Server：如何查询最后一次事务日志备份的时间

查询最后一次事务日志备份的时间

sql
SELECT TOP 1
    bckup.backup_finish_date AS '最后一次事务日志备份时间'
FROM
    sys.fn_dblog(NULL, NULL) fn
    INNER JOIN sys.dm_db_log_stats(NULL, NULL) stats ON fn.[Current LSN] = stats.[Last Backup LSN]
    INNER JOIN sys.database_recovery_status rec ON stats.[database_id] = rec.[database_id]
    INNER JOIN msdb.dbo.backupset bckup ON rec.last_log_backup_lsn = bckup.backup_lsn_start
WHERE
    bckup.type = 'L'
ORDER BY
    bckup.backup_finish_date DESC;