December 24, 2007 at 8:44 am
Hi,
I need to synchronize the system clock of two servers. Is there a way I can update the system clock of one system with that of the other?
Thanks
And Merry Christmas to all 🙂 ... May lord always be praised
December 24, 2007 at 9:53 am
This is a windows issue, not a SQL issue. SQL takes it's time from the windows system.
Look up time servers. You should have a server on your network that acts as a time server and all other servers (and workstations) synch with it.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 24, 2007 at 10:37 am
It is usually done by implementing/using a ntp-service (network time protocol)
December 31, 2007 at 3:17 am
This needs to be fixed by your Windows Infrastructure people. All servers in a domain need to have their time synchronised otherwise AD can get very upset. If the server time is too far away from the domain time, the server account will be locked out of the domain. Other, more serious, problems can also occurr. If you have a server that is not synchronised, raise a problem ticket to get time synchronisation fixed.
At my old place, for a while they had a standard that desktop machines would not be included in time synchronisation (this eventually changed...). We had a few desktopss running MSDB where we wanted the time synchronised, so we set up a weekly SQL Agent job to run NET TIME /DOMAIN:ourdomain /SET. This fixed the problem for us, but it is far better that the proper Windows service manages the time synchronisation.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply