October 15, 2002 at 5:44 am
Hello,
does the change from Summer to Wintertime influence the Timestamps in the
Cluster and Transaction Logs of an Windows 2000 SQL2000 Cluster. In Europe,
we will have the Same Hour two times.
Regards
Rainer
October 15, 2002 at 10:07 am
Timestamps (datatype) are not related to hours and dates, rather, they are incremental trackers for the transaction logs.
The datetime fields you have may indeed get duplicates when the times change. Not sure how to handle this as technically, there are 2 11:10s on that day (or whatever the time is).
Steve Jones
October 15, 2002 at 11:13 am
I've got the Question from a Customer, who is in sorrow that his Transaction Logs get double Timestamps and will not be able to recover. I don't know which time SQL-Server uses internally for the logfiles.
October 15, 2002 at 12:38 pm
What type of timestamp is it. SQL stores most all date time values as an integer in the background. The presentation layer converts to the local time zone based on the OS settings. He should not have two timestamps under any condition where the time change would affect it. Now if you are talking about inside msdb sysbackup tables or on the list they should remain in order as they also have an ID value associated with them and not just time.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply