Lee Markum reviews backup logs:
As data professionals responsible for SQL Server, it is drilled into our heads that we need to take backups. But, how do we know we actually have backups available to us when we need them? How can we verify that a backup has been taken? Some types of auditing that an employer has to undergo might require proof of backups. How will you provide it?
Read on for three options. Note that this post is about finding the existence of backups, not checking to see if the backups are any good.