One question though: when having to restore to a specific point in time using STOPAT can I trust the "BackupStartDate" column returned by the following code?
That would be an easier way to identify which log backup I really need to stop at before performing the actions?
Hi Andre,
Yes, this is quite a tricky area. That query might at least help you identify that this was the log backup taken right after whatever the "unfortunate event" happened to be. The degree of difficulty of a p-i-t restore rather depnds though on how accurately you know the exact time the problem occurred. The best discussion of an alternative that I've found, if you're really unsure of the time, is based on restoring to an LSN instead: http://janiceclee.com/2010/07/25/alternative-to-restoring-to-a-point-in-time/.
Cheers,
Tony.