Proper Shutdown of SQL Servers in a Cluster

  • Hi, First time posting and I'm a newbie. Can anyone tell me the proper steps for how to shutdown both SQL servers in an active/passive cluster. Do I first stop SQL services running on the cluster -then do physical shutdown of the passive node and then active node? Do I also have to stop cluster services prior to shutting down? Or does it not really make a difference - SQL will take care of itself in a power down? I can find procedures on how to properly stop services but not how to shutdown the servers properly. Thanks for your help!

  • I recently started using Shutgui.exe. This shuts down or reboots your system depending on the options you choose. Once the primary node comes up, I reboot the other one with the same tool. Here is a link to download the utility. There are bunch of other utilities, you may want to use the search for shutgui.exe

    http://www.dynawell.com/support/ResKit/win2k.asp

    Shas3

  • quote:


    Can anyone tell me the proper steps for how to shutdown both SQL servers in an active/passive cluster.


    Shutdown the application, Use Cluster Administrator to take SQL Server resources offline, shutdown the passive node and then the active node.

  • I'll second Allen.

    Don't use any of the typical tools that work great on a non-clustered system. You must treat clusters differently because you have two (or more) servers that are interconnected.

    That means no Service Control Manager, no Enterprise Manager, no NET STOP, no Services.msc, or anything of that sort.

    BTW, if you need to script the shutdown, you can use the cluster command in order to bring resources off-line and then back on-line.

    For instance:

    cluster /cluster:<Cluster Name> group "<SQL Server Group Name>" /OFFLINE

    Then go about the shutdown with the normal tools first with the passive then the (formerly) active node.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • quote:


    Thank you for your help. Sorry if I'm being a knucklehead, but I want to be very specific:

    1. Go to start - programs - administrative tools and then cluster administrator

    2. Highlight the resources

    3. Highlight and right click on SQL Server, SQL Server Agent and SQL Server Full Text and take each offline

    4. Then go to start - programs - shutdown

    Is that all? I guess it makes sense to not stop cluster service right because you want that to be on when it comes back up so that it can then start up the SQL service on whichever node it wants to? Am I thinking right about this?

    quote:


    Can anyone tell me the proper steps for how to shutdown both SQL servers in an active/passive cluster.


    Shutdown the application, Use Cluster Administrator to take SQL Server resources offline, shutdown the passive node and then the active node.


  • It's probably easier to bring the entire group offline and then bring it online after the reboot.

    The cluster service is just that, a service. It's typically set to start up automatically on reboot (you check this with services.msc). On a cluster, SQL Server and the Agent should be set to manual since the cluster service will determine when to start them.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • Reboot one after the other node, never shutdown both at the same time.

    Use Cluster Administrator to initiate failure so the other nodes becomes the owner of all resources. Never take 'Off Line' use initiate failure.

  • Agree with Jay_durai. I dont see a need why you are on a cluster env and need to shutodwn the nodes at the same time. If you are doing maintenance (not SQL) on the servers, perform the activities first on the passive node(designated secondary), then initiate the failure using the cluster admin and perform your activities on the other node (designated primary). you may want to bring your resources back to your primary server.

  • quote:


    Hi, I guess I should have explained that we had a serious power outage and our USP gave the network admin 10 minutes in which to shutdown all servers. We kept getting irratic power with surges -things like that so she decided to do a hard shutdown of all the servers and the question came up as to how she should have properly done that. This was not a case of needing to initiate a failover but of literally shutting down the SQL cluster. Hope this helps clarify. Thanks to all for your responses!

    Agree with Jay_durai. I dont see a need why you are on a cluster env and need to shutodwn the nodes at the same time. If you are doing maintenance (not SQL) on the servers, perform the activities first on the passive node(designated secondary), then initiate the failure using the cluster admin and perform your activities on the other node (designated primary). you may want to bring your resources back to your primary server.


  • I have a shutdown script where I shutdown one server about 30 seconds after the second just for the case you've indicated. This ensures the nodes go down gracefully and you don't have the cluster service trying to bounce between the two.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • quote:


    Can you share an example of that script and does it run from sql server agent?

    I have a shutdown script where I shutdown one server about 30 seconds after the second just for the case you've indicated. This ensures the nodes go down gracefully and you don't have the cluster service trying to bounce between the two.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1


  • it's a .cmd file and I use shutdown.exe from the Resource Kit, though I'll be switching that to psshutdown because it honors the power down as well. It's manually executed by an administrator if needed.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • Hi!.

    I have the same question on how to make a safe shutdown of all the server in my Active-Active-Active-Active SQL2000 cluster on Win2003 IA64 System. Any body have an Idea on what the Proper way is to do it?

    Best regards

    Baldini

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

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