Sql services on FC - Recovery

  • Hi All,

    I have a FC sql server clustered environment using shared storage.

    How do you do with the Recovery options of the sql server services?

    Default for

    First failure: Take No Action

    Second failure: Take No Action

    Subsequent failures: Take No Action

    I used to set them for a stand-alone server, but is it still fine for the FC env?

    Igor Micev,My blog: www.igormicev.com

  • The Recovery tab is opened when you see the Properties of the sql server service in the Services, not in the sql server configuration manager.

    Anyone's experience on this?

    Igor Micev,My blog: www.igormicev.com

  • You are correct, take no action (defaults) in services for all three is correct and there is no need to change them (defaults) - remembering the sql server services are always controlled (started/stopped/failover) from the Failover Cluster Manager.

  • RVarn (3/2/2016)


    You are correct, take no action (defaults) in services for all three is correct and there is no need to change them (defaults) - remembering the sql server services are always controlled (started/stopped/failover) from the Failover Cluster Manager.

    And I was thinking the same, but wanted someone to overlap with it. Thanks.

    Igor Micev,My blog: www.igormicev.com

  • You may be interested in looking at these cluster level configs:

    https://technet.microsoft.com/en-us/library/cc755151.aspx

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

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