SQL Server:如何查询上次事务日志备份的时间? [英] SQL Server: how to query when the last transaction log backup has been taken?

问题描述

我想查询所有数据库(在SQL Server 2008实例中)在执行上一次事务日志备份时的日期.怎么做?我知道这些信息在某个地方，但是我不知道在哪里.

I would like to query for all databases (in SQL Server 2008 instance) date when the last transaction log backup has been taken. How to do that? I know that this information is somewhere, but I don't know where.

推荐答案

SELECT   d.name,
         MAX(b.backup_finish_date) AS backup_finish_date
FROM     master.sys.sysdatabases d
         LEFT OUTER JOIN msdb..backupset b
         ON       b.database_name = d.name
         AND      b.type          = 'L'
GROUP BY d.name
ORDER BY backup_finish_date DESC

这篇关于SQL Server:如何查询上次事务日志备份的时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！