April 13, 2011 at 11:55 am
My QA team is asking for the ability to change the server time to perform some testing. The server is part of the AD domain with NTP.
My thought is to remove it from the domain in order to force the time change, but I am more worried about what the time change will do to the logs, etc.
2 questions:
- will changing the time back and forth will transactions are being performed screw up the logs?
- what is the standard method for doing this form of db application time/date testing?
Thank you
April 15, 2011 at 11:14 am
Just Stop the [Windows Time] Service so it stops synchronizing with your Domain Controller.
You DO NOT need to disjoin your server from your Domain.
Once you are done testing, Start the Service again and run this command from a DOS prompt window:
w32tm /resync
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply