March 2, 2016 at 3:40 am
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
March 2, 2016 at 2:13 pm
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
March 2, 2016 at 2:29 pm
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.
March 2, 2016 at 5:04 pm
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
March 3, 2016 at 10:26 am
You may be interested in looking at these cluster level configs:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply