SQL Services restarted?

  • In a cluster, if we reboot one node, is the SQL Server sercives restarted?

    I guess not, any other opinion?

    Many thanks in advance.

  • If it's the active node you're rebooting, yes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • SQL ORACLE (8/4/2011)


    is the SQL Server sercives restarted?

    I guess not, any other opinion?

    Many thanks in advance.

    Even if is clustered or not if you restart the server the services should be dependent on service property

    "Manual/Automatic" start service on restart.

    Run---> Services-->Select Service--Double cliick...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • @SQLFRNDZ

    I cannot get your point.

  • GilaMonster (8/4/2011)


    If it's the active node you're rebooting, yes.

    If so, any running job will be killed?

  • SQL ORACLE (8/4/2011)


    GilaMonster (8/4/2011)


    If it's the active node you're rebooting, yes.

    If so, any running job will be killed?

    Sure.

    -- Gianluca Sartori

  • SQL ORACLE (8/4/2011)


    GilaMonster (8/4/2011)


    If it's the active node you're rebooting, yes.

    If so, any running job will be killed?

    Couldn't agree with you more about @SQLFRNDZ's comment, and why would you want to [start\stop] SQL services within a cluster using windows services?

    From what I understand if you do([start\stop] services not within cluster) it like this your cluster isn't going to function properly.

    What you don't know won't hurt you but what you know will make you plan to know better
  • duda (8/5/2011)


    Couldn't agree with you more about @SQLFRNDZ's comment, and why would you want to [start\stop] SQL services within a cluster using windows services?

    From what I understand if you do([start\stop] services not within cluster) it like this your cluster isn't going to function properly.

    This isn't about manually stopping a service. The question was, if a node of the cluster is rebooted, will the SQL service stop and restart as a result of that reboot.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • SQL ORACLE (8/4/2011)


    GilaMonster (8/4/2011)


    If it's the active node you're rebooting, yes.

    If so, any running job will be killed?

    All connections will be dropped, all open transactions roll back. Once the SQL service on the active node as stopped, the cluster admin will start it up on the other node. Jobs will have to be restarted and applications will have to reconnect.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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