Post reply

best procedure to "shut down" a database/sql instance?

  • August 9, 2011 at 2:16 am

    #242968

    for patching we have to occasionally reboot servers. To shutdown sql server I can simply stop the sql service before shutdown.

    Although this has not caused problems, I would like to know if there is a better solution, or perhaps a recommended db/instance shutdown process.

    ( i have googled but found nothing concrete, i.e in a technet/msdn article)

  • August 9, 2011 at 3:13 am

    #1365693

    SQL config manager (or services manager, or cluster admin) stop service.

    Or you can just reboot, that will stop the service during the shutdown

    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

  • August 9, 2011 at 3:16 am

    #1365697

    Is there is difference between shutting down from the MMC vs simply running the shutdown command in SSMS ?

    Jayanth Kurup[/url]

  • August 9, 2011 at 3:29 am

    #1365711

    No. Both stop the service.

    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 4 posts - 1 through 4 (of 4 total)

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