October 24, 2001 at 2:57 am
Anybody having experience with SQL servers running while time resets from daylight saving time to ordinary time, I'm particularly interested in the possible affects on recovery based on the transaction log.
October 24, 2001 at 9:49 am
Haven't really noticed problems, but we haven't worked much with time. Dates are more important.
Luckily no crashes on during the switches. Since the T-log uses a numbering scheme (rather than a time scheme), I would think there would be no issue on the recovery.
Steve Jones
October 26, 2001 at 12:52 am
I covered this issue with the Y2k compliance stuff.
SQL 6.5 required you to stop the services before changing the system time.
SQL7/2000 did not have a problem with changes to the system time while services running.
It is always best to do some testing before jumping in with your production system.
October 26, 2001 at 8:06 am
I would be surprised if it broke - you'd think any critical time would be stored as UTC, translated for display.
Andy
October 26, 2001 at 9:41 am
Thank you for the answers. I'm not worried about the servers surviving the change of time. It is the possible recovery to point in time that worries me. What will happen if I try to recover to point-in-time in the hour that occurs twice? Will I be able to recover to point in time after the change of time using backups from before and logs spanning the hour occurring twice?
October 26, 2001 at 10:33 am
If you are really concerned, do a backup at the beginning of the hour, right before the time change, and then one later.
Steve Jones
October 26, 2001 at 10:39 am
That is also my intention. Just to safe.
October 26, 2001 at 4:17 pm
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply