I am log shipping between two SQL Server 2008 servers. This is our own log shipping and not the built in (we have 500+ databases and it is easier this way). I want simple monitoring to make sure the fail-over site has the latest transaction logs.
How can I tell the latest transaction log that was restored to a database?
Can I tell the date/time that the log was backed up from the source server?