Post reply

Need to change time on SQL server, how will this affect transactions?

  • September 19, 2011 at 6:37 am

    #244017

    I have a SQL server that serves a intense webshop with ~3500 transactions every hour 24/7.

    I need to change the server time on this server (back ofcourse 🙁 ), how will this affect the transactions?

    That is that I can have two transaction with 10 minutes apart and the last one is happening before the first one.

    Is the SQL server taking care of this or do I need to stop the service, change the time and then start the service again?

    /M

  • September 19, 2011 at 6:39 am

    #1383276

    Unless there's something in your SQL code that's time-dependant (do check), it won't have any effect.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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