Changing system clock affecting SQL Server

  • Does anyone have problems with SQL Server 7.0/2000 when frequently changing the Windows NT Server system clock. I am not talking about violating primary keys either. I am getting ready to implement the auto time synchronization on 5 servers (with SQL) on the network and just don't want to mess anything up since these are live systems. Thanks.

  • We use it on all our servers, including all our SQL Servers, and have had no ill effects.

    Our environment may not be the best acid test as we do not have any time CRITICAL applications so, you may want to wait for some other posts to make sure that I am not alone.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • There are some posts here. I noticed a delay in SQL Server getting the update, I think 40 sec on SQL 2K, W2K.

    Search these forums and you'll see a thread.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply