Post reply

Clustering - SQL Services

  • July 28, 2009 at 12:49 pm

    #140186

    Hi

    I have a Cluster setup and on the "added node" the SQL Services are showing as Startup Type => manual (That's how they showed at the time of adding a node, the option was Greyed out and did not let me touch it). My question is , in the case of a failover should the DBA intervene to start the Service or does it automagically bring it up? And if so how much time does it take?

    Thank you

    ====================================

    Experience is what you learn from mistakes

  • July 28, 2009 at 1:26 pm

    #1031280

    Upon failover the cluster service will startup all services included in the cluster group thus if the sql server services are in the cluster group that is failing over then there is no need for manual intervention.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • July 28, 2009 at 1:27 pm

    #1031281

    The clustering handles that. When it fails over it stops resources on one node and starts them on the other.

    CEWII

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

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