Unanswered: Restoring during Daylight Saving Time conversion
Here is an idle speculation question that came up, but I do not have an answer for.
At 2:00 AM on Oct. 31, we enter/leave (I never get it straight) Daylight Savings time. This means, we get to live through 2004-10-31 01:00:00.000 to 2004-10-31 02:00:00.000 twice, in somewhat rapid succession. The question is, what do you do if you need to restore a database to a point in time during that 2 hour window. One theory is to set a log mark at the second 2004-10-31 01:00:00.000, in order to differentiate the two hours. I am somehow not satisfied with that.
Like I said. This is an idle speculation, and could well be forgotten on Nov 1.