Post reply

how to set sql services to manual and shut down the server

  • July 30, 2012 at 12:54 pm

    #278759

    How to set all the sql server services to MANUAL

    and shutdown all sql services?

  • July 30, 2012 at 1:12 pm

    #1519371

    Administrative tools -> services. You can do both from there.

    Why do you want to do this? Automatic doesn't means automatically restart, just automatically start when the server starts

    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

  • July 30, 2012 at 1:22 pm

    #1519375

    we are moving our servers to diff location

  • July 30, 2012 at 1:33 pm

    #1519384

    Hmm... Sounds like you may want to get someone that knows what they are doing. I'm not trying to demean you, but there are several other things to consider besides your services when moving/migrating a server.

    Jared
    CE - Microsoft

  • July 30, 2012 at 1:44 pm

    #1519390

    Could be they are physically moving servers from one location to another and don't want SQL Server coming up when they do the initially testing of the servers on power up at the new location.

  • July 30, 2012 at 1:50 pm

    #1519398

    Lynn Pettis (7/30/2012)

    Could be they are physically moving servers from one location to another and don't want SQL Server coming up when they do the initially testing of the servers on power up at the new location.

    Could be, but look at all of the other posts by the same user 🙂

    Jared
    CE - Microsoft

  • July 30, 2012 at 1:56 pm

    #1519404

    yes you are right, we are moving physically.

Viewing 7 posts - 1 through 6 (of 6 total)

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