Koen Verbeeck (3/8/2011)

---

Ol'SureHand (3/8/2011)

---

Not sure I get the point of the trick question.

It should be clear that you can restore to ANY point in time (at each 15 minute interval in this example). However, restoring to the 9:30 state will not recover your TRUNCATEd table ... so was that thrown in as a red herring ?

If so, it got me ...

The question asked: Is it now possible to restore to a given point in time?

It is possible, so the answer is certainly yes. The question didn't ask if it was possible to restore that specific table to any given point in time.

Anyway, nice question.