Help: System Time is Wrong
The Windows system time is wrong on my server. It is 12 hours ahead. i.e Instead of 8am it is 8pm. The database is in use 24x7 running an accounting / trucking system.
Can anyone recommend a method to change the time back 12 hours without incuring any data loss or other negative anomolies?
I don't mind stopping SQL Server for a couple hours to correct the problem. As a worst case scenario, I wondered if I stopped SQL Server, reset the system time back 12 hours, and started SQL Server 12 hours later, if that would work... what do you think?
I backup the transaction logs offsite every 15 minutes and restore them to a recovery server at the offsite location.
Any help would be greatly appreciated. TIA
Configuration:
Windows Server 2003
SQL Server 2000
Software/Hardware used:
Software/Hardware used:
ASKED:
March 13, 2007 10:48 AM
UPDATED:
March 13, 2007 3:22 PM
Answer Wiki:
Bad situation. You would need to determine the impact on your applications and data if you just set the time back. Issues such as invoices be paid before they are generated, trucks and freight arriving at destinations before the left.
You best bet may be to determine what data is time sensitive, which data is incorrect and how to fix it/update to the correct time. Stop access to the system off hours, set the time and fix the data.
Charles Deaton
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
