Thanks! We'll email you
when relevant content is
added and updated.
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
Windows Server 2003
SQL Server 2000
March 13, 2007 10:48 AM
March 13, 2007 3:22 PM