Great that someone reminds us of this. Although all DBA's should be familiar with restoring to a point in time.

One thing in the article which I found not so clear is that when you meet a recovery situation the first thing to do is to backup the current log. I would do it before anything else and after that put out alerts to end users etc.

By the way differential backups may become very handy also when full backup intervall is not so dense. With differential backups you don't have to restore trn-logs only just after the restoration of the last differential backup.

Also if you make a database maintenance plan (with ent.manager or otherwise) you should also test it, restoration too!

- JARI -