There’s an old saying in computers, your data is only as good as your last backup. There is a little known corollary to that saying; your backups are only as good as your last restore. In this article based on chapter 7 Learn SQL Server in a Month of Lunches, author Grant Fritchey shows how to use log backups in order to get your database to a particular point in time as part of an emergency.

Restoring to a Point in Time (PDF)