Help: System Time is Wrong

0 pts.
Tags:
SQL Server
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
ASKED: March 13, 2007  10:48 AM
UPDATED: March 13, 2007  3:22 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following