Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Minimum number of Replicas needed - at least three? Expand / Collapse
Author
Message
Posted Thursday, April 24, 2014 1:13 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 3:54 PM
Points: 211, Visits: 520
I'm scratching the surface of AO. I currently have one SQL 2012 FCI on a WSFC. Which means one Active node at a given time? I cannot set up an AO with this, can I? Logically speaking I need “at least two” active (up & running) SQL Server instances to set up. And in your example you used a total of 5 nodes, and the minimum would be 3 for a AO on FCI + WSFC rt?

Here is what my FCI looks like,

there is no point in having AO when only 1 instance of SQL is running at a given time. Right ?

If yes what would I need to set up AO
A new Node in the Cluster or
Any other Stand alone SQL Should(same version) do as well ?



Today is the tomorrow you worried about yesterday
Post #1564835
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse