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