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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP