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 12»»

AlwaysOn 2014 Expand / Collapse
Author
Message
Posted Wednesday, April 23, 2014 9:24 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:31 PM
Points: 33,051, Visits: 15,159
Comments posted to this topic are about the item AlwaysOn 2014






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1564504
Posted Wednesday, April 23, 2014 11:49 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:47 AM
Points: 453, Visits: 121
Thanks Steve. A tricky question.

The MSDN library on this is contradicting.

The first article in the links below states
An availability group supports a set of read-write primary databases and one to four sets of corresponding secondary databases.
and the second article states
An availability group supports a set of primary databases and one to four sets of corresponding secondary databases.


http://technet.microsoft.com/en-us/library/hh510230%28v=sql.120%29.aspx
http://technet.microsoft.com/en-us/library/ff877884%28v=sql.120%29.aspx

Post #1564522
Posted Thursday, April 24, 2014 12:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
I have also found contradicting information:

Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary databases, and one to four secondary replicas, ...


Overview of AlwaysOn Availability Groups (SQL Server)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1564530
Posted Thursday, April 24, 2014 12:35 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:55 PM
Points: 1,668, Visits: 739
I agree with the the two previous posts.. conflicting information out there

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1564542
Posted Thursday, April 24, 2014 3:29 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:06 AM
Points: 3,850, Visits: 4,988
Interesting question, thanks Steve.
Had to read up on this. The conflicting info in MSDN almost tripped me up...


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1564588
Posted Thursday, April 24, 2014 3:31 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:06 AM
Points: 447, Visits: 1,657
Damn it, I knew the answer but clicked on the wrong button .
Post #1564589
Posted Thursday, April 24, 2014 3:31 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:06 AM
Points: 447, Visits: 1,657
Damn it, I knew the answer but clicked on the wrong button .
Post #1564590
Posted Thursday, April 24, 2014 4:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 1,010, Visits: 2,097
I found the answer is 8 looking here: http://sqlmag.com/database-high-availability/changes-sql-server-2014-alwayson-availability-groups.
Post #1564600
Posted Thursday, April 24, 2014 5:23 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:13 AM
Points: 679, Visits: 1,001
Found the answer in BOL: up to 8 secondary replicas, including 2 synchronous secondary replicas
Source: http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx#High_availability
Post #1564609
Posted Thursday, April 24, 2014 7:43 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 5:36 PM
Points: 8,545, Visits: 9,033
Interesting question.

I found the wrong answer in BOL: (the SQL server 2014 version of) Overview of AlwaysOn Availability Groups (SQL Server) states that 2014 supports only 4 secondary replicas (plus 1 primary replica) for an always on availablility group.

I guess I shouldn't believe BOL without first looking to see if it contradicts itself.


Tom
Post #1564654
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse