Post reply

SQL Server shutdown on a cluster

  • June 11, 2020 at 5:49 am

    #3762176

    I have SQL Server 2014 running on a Windows 2012R2 2 node cluster. We are moving to a new storage array and have to shut down SQL services while this is done. I am unsure as to the best way to approach this.

    Through the failover cluster manager do I

    1.       Stop the instance role

    2.       For the instance take the SQL Server and SQL Server Agent resources offline

    Also, do I need to uncheck auto restart SQL Server and SQL Server Agent from SSMS Agent properties

  • June 12, 2020 at 6:10 am

    #3762533

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • June 16, 2020 at 8:42 pm

    #3763644

    If SQL is clustered, ALWAYS use the cluster manager to start/stop SQL (take the resource offline/bring the resource online).  Also, if you take SQL offline the SQL Agent will be stopped as well if everything is setup correctly (dependencies).

  • July 15, 2020 at 2:35 am

    #3769997

    Assuming an AlwaysON environment.

    1. Pause any synchronization between nodes by Stopping secondary node.

    2. Shutdown seconday node

    3. Shutdown Primary node

    4. Do the changes to storage

    5. Bring Primary node online

    6. Bring decondary node online

    7. Resynchronize

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

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