Post reply

Stopping SQL Services on a sql 2008 Cluster

  • November 9, 2015 at 12:40 pm

    #302170

    Hi Guys

    Whats the best way to stop/pause sql services on a cluster for maintenance.

    failover should not happen.

    Thanks

  • November 9, 2015 at 2:27 pm

    #1838704

    Use SQL Configuration Manager is the only way to go.

  • November 10, 2015 at 1:35 am

    #1838767

    What if the node needs a reboot during the maintenance? Do you want a loss of service?

    Generally my stance on maintenance at the OS layer for SQL Clusters is

    a. physical boxes, use Acronis to take a OS backup for rollback just in case it goes wrong

    b. virtual boxes, create a snapshot of the VM before doing anything for rollback just in case it goes wrong

    then

    pause the passive node, do what I need to do, resume the host, failover test the hell out of what I've just done, if everything ok, pause the now passive node, do maintenance, resume the host, failover, test the hell out of what I've just done.

  • November 10, 2015 at 1:40 am

    #1838768

    anthony.green (11/10/2015)

    What if the node needs a reboot during the maintenance? Do you want a loss of service?

    Generally my stance on maintenance at the OS layer for SQL Clusters is

    a. physical boxes, use Acronis to take a OS backup for rollback just in case it goes wrong

    b. virtual boxes, create a snapshot of the VM before doing anything for rollback just in case it goes wrong

    then

    pause the passive node, do what I need to do, resume the host, failover test the hell out of what I've just done, if everything ok, pause the now passive node, do maintenance, resume the host, failover, test the hell out of what I've just done.

    or

    If its a mirrored OS, power down, remove a disk. Power up, perform upgrade/maint. If it goes sideways, power down swap disks and power on, OS will be in original state, place in disk and let rebuild occur

    _________________________________________________________________

    "The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864

  • November 10, 2015 at 4:41 pm

    #1839007

    alnoor (11/9/2015)

    Hi Guys

    Whats the best way to stop/pause sql services on a cluster for maintenance.

    failover should not happen.

    Thanks

    Stop the clustered SQL Server resource using powershell

    stop-clusterresource "sql resourcename"

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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