How does rolling back domain time affect database applications

Hi All
One of our hosted clients is not syncing from an external time source and as such is approx 20 mins ahead. Not a problem for us but our backup and tape change teams are logging times and want everything neat and tidy.
I was thinking of rolling back time on the pdc emulator (maybe 3 mins at a time).

My question is, how will this affect any SQL/exchange/oracle apps that are using time for logging etc.

Is there a best practice for dealing with this?

__________________
A.Rajesh Khanna

Hi,

please follow meinolf weber suggestion

I would also suggest you to post your query under SQL forum so that they would give you the impact on the database front.
For your convinience i am pasting the below link

SQL Server Category


best of luck.

__________________
Shaalini.S
Be the Best of Whatever you are...

hi,

tested (in lab) rolling back time on pdce by 3 mins

I used W32tm /stripchart to monitor what would happen. I hoped that the other DCs would roll back their times gradually but the time client instantly rolled back its time when it next synced. I would assume this will then happen on member servers running SQL, oracle etc. Therefore, would it cause problems with timestamping of transaction logs etc...

When/if this work is done, i will point the pdce to our external time source

Thanks again for your help

__________________
A.Rajesh Khanna