Best technique for shutting down VM upon which MSSQL is running

  • We're looking to establish an official server shutdown order, in case of an emergency. All of our MSSQL instances are running on VM's. There are 4 general shutdown options that we're coming up with, one of which doesn't fit the emergency scenario:
       1) VM's "Power Off" option
       2) VM's "Shutdown Guest" option
       3) Logging into the machine, shutting down from the Windows icon 
       4) Remotely executing a shutdown command with an authenticated Windows account: shutdown /s /m \\myserver /t 0 /d p:0:0 /c "Planned server shutdown"

    Option 1 is like pulling the plug, so we're not considering it. Option 3 is too time consuming for an emergency scenario, so we're not considering it, either. It would be the easiest to go with option 2, but I seem to remember reading something that while Shutdown Guest is better then Power Off, actually shutting down the server with an authenticated user is the best way to go. Has anyone else heard the same, or have any links around to some websites that can offer up more detail? I tried searching around, but I couldn't find the right key words.

    Thanks,
    --=Chuck

  • chuck.forbes - Thursday, January 17, 2019 2:14 PM

    We're looking to establish an official server shutdown order, in case of an emergency. All of our MSSQL instances are running on VM's. There are 4 general shutdown options that we're coming up with, one of which doesn't fit the emergency scenario:
       1) VM's "Power Off" option
       2) VM's "Shutdown Guest" option
       3) Logging into the machine, shutting down from the Windows icon 
       4) Remotely executing a shutdown command with an authenticated Windows account: shutdown /s /m \\myserver /t 0 /d p:0:0 /c "Planned server shutdown"

    Option 1 is like pulling the plug, so we're not considering it. Option 3 is too time consuming for an emergency scenario, so we're not considering it, either. It would be the easiest to go with option 2, but I seem to remember reading something that while Shutdown Guest is better then Power Off, actually shutting down the server with an authenticated user is the best way to go. Has anyone else heard the same, or have any links around to some websites that can offer up more detail? I tried searching around, but I couldn't find the right key words.

    Thanks,
    --=Chuck

    option 1 always a no no.
    option 2 only if you have vmtools installed on that vm - this will enable for a standard shutdown and clean up script. if vmtools is not installed then it is the same as option 1.
    otherwise option 3 or 4 - both are the same but 4 allows for scripting and doing it remotely - but does require rmat to be installed and configured (not much to it anyway)

  • I guess, then, what I am wondering is if vmtools is installed on the server, is there any real difference between options 2, 3 & 4? Because there's a slick way of putting servers into groups, and running a "shutdown guest" against them all, using something called VApps in VMWare.

    --=Chuck

  • chuck.forbes - Thursday, January 17, 2019 4:48 PM

    I guess, then, what I am wondering is if vmtools is installed on the server, is there any real difference between options 2, 3 & 4? Because there's a slick way of putting servers into groups, and running a "shutdown guest" against them all, using something called VApps in VMWare.

    --=Chuck

    Assuming that VApps does a real shutdown guest all 3 are the same from a end state point of view.

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

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