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.

sql sql-server sql-server-2008 backup transaction-log
Edit
Report