Is there an easy way to query last backup date for log-files for a specific SQL Server instance (i.e. for all databases), but only the log file as opposed the database files? This is a MSSQL 2005 instance.
Also – as log files are for point in time recovery – should you be backing them up regularly, i.e. hourly, or do you just back them up each day – and which point you could restore to any given point during that day?