Post reply

Restart Windows Server with SQL after updates

  • February 23, 2015 at 6:56 am

    #398059

    Dear all - Just wondered, is it ok to just simply restart a Server which has SQL2008 residing on it, after applying Windows Updates?

  • February 23, 2015 at 7:02 am

    #1779247

    If the updates require a Windows restart, go for it. You'd better do it when users are not using the database, so plan downtime with them.

    -- Gianluca Sartori

  • February 23, 2015 at 7:06 am

    #1779248

    I take it it's safe to just restart without stopping the SQL Service?

    Many thanks

    Dax

  • February 23, 2015 at 7:12 am

    #1779250

    Perfectly. To be honest, it's fairly safe (at least from SQL's side) to just power off without any form of clean shutdown (my home server will attest to that, having had power cut 2+ times a week for the last 2 months).

    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

  • February 23, 2015 at 7:16 am

    #1779252

    Thanks very much for that, just looking for some reassurance.

    Kind Regards

    Dax

Viewing 5 posts - 1 through 4 (of 4 total)

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