Changing System Time on SQL Server Hardware

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Caleb (anonymous_at_discussions.microsoft.com)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 08:52:20 -0700

I'm trying to test a web-based, time and attendance
application. In order o compress the testing window, I'd
like to adjust the system time. The application pulls all
time stamps from the database server so when I need to
adjust the system time, I will be adjusting the database
server (SQL Server) time forward and backward.

I'm being told that if I adjust the system time on the
database tier (SQL Server) that I will destabilize the
database (specifically causing trouble with log files) and
my results will not be reliable. In the past while
testing a time sensitive, client/server application, I
adjusted the system time forwards and backwards without
any negative repercussions.

I'd like to know what would cause this instability, if the
information that I'm receiving is accurate and if there
are any suggested workarounds.

Relevant Pages

  • Re: Changing System Time on SQL Server Hardware
    ... Jasper Smith (SQL Server MVP) ... > like to adjust the system time. ... I will be adjusting the database ...
    (microsoft.public.sqlserver.server)
  • Re: what make system time changes?
    ... Another thing that might be affecting this is if incorrect changes were made when applying DST fixes for the newdates. ... When we had Daylight saving time effective weeks ago, the system time of this machine failed to adjust automatically. ...
    (microsoft.public.win2000.general)
  • Re: what make system time changes?
    ... to adjust automatically). ... For software compatibility and other reasons we haven't upgraded this ... Two days ago I started to adjust the system time from say 13:15 to 14:15 ... I have tried to set & unset the "automatic adjust DST" checkbox, ...
    (microsoft.public.win2000.general)
  • Re: keeping time
    ... It can set your system time to "BIOS" time directly, ... note the section about the "Adjust" section and how it ... Using 'hwclock --show', ... Also check out the adjtimex package. ...
    (Ubuntu)
  • Re: what make system time changes?
    ... When we had Daylight saving time effective weeks ago, the system time of this machine failed to adjust automatically (although I have the checkbox on to adjust automatically). ... For software compatibility and other reasons we haven't upgraded this machine. ...
    (microsoft.public.win2000.general)