Home Forums SQL Server 7,2000 Administration Proper Shutdown of SQL Servers in a Cluster RE: Proper Shutdown of SQL Servers in a Cluster

  • July 16, 2003 at 2:24 pm

    #465742

    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