Time synchronization
Whenever you use replication that requires time stamp, time stamp with a stored procedure, or delete wins conflict resolution, you must synchronize the operating system times of the database servers that participate in the replicate.
All timestamps and internal computations are performed in Greenwich Mean Time (GMT) and have an accuracy of plus or minus one second.
Important: Enterprise Replication does
not manage clock synchronization between database servers that participate
in a replicate. You should use a product that supplies a network time
protocol to ensure that times remain synchronized. For information
on tools for synchronizing the times, refer to your operating system
documentation.
To synchronize the time on one database server with the time on another database server, use one of the following commands, where hostname or servername is the name of the remote database server computer.
- UNIX™
rdatehostname- Windows™
net time \\servername/set
Important: These commands do not guarantee the
times will remain synchronized. If the operating system times of the
database servers do become out of sync or if their times move backward,
time stamp or stored procedure conflict resolution might produce failures
caused by incorrect time stamps.