SQL Server: how to query when the last transaction log backup has been taken?

Viewed 40573

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.

2 Answers
Related