AlwaysOn 2014

Question

Post reply

AlwaysOn 2014

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
April 23, 2014 at 9:24 pm

#74768

Comments posted to this topic are about the item AlwaysOn 2014
April 24, 2014 at 3:29 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

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

TjhomasH6610 SSCommitted Points: 1690 More actions · Answer 1

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

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)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 3

I agree with the the two previous posts.. conflicting information out there

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 4

Damn it, I knew the answer but clicked on the wrong button :-D.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 5

Damn it, I knew the answer but clicked on the wrong button :-D.

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 6

I found the answer is 8 looking here: http://sqlmag.com/database-high-availability/changes-sql-server-2014-alwayson-availability-groups.

Louis Hillebrand SSCarpal Tunnel Points: 4982 More actions · Answer 7

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

TomThomson SSC Guru Points: 104773 More actions · Answer 8

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 9

The 2014 BOL updates have lagged a bit and I suspect there are doc issues. There are 8 in 2014. If you see it documented as 4, please submit a bug.

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

Steve Jones - SSC Editor (4/24/2014)
The 2014 BOL updates have lagged a bit and I suspect there are doc issues. There are 8 in 2014. If you see it documented as 4, please submit a bug.

I thought it was 4, but turned out to be 8 :w00t:

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

TomThomson SSC Guru Points: 104773 More actions · Answer 11

Steve Jones - SSC Editor (4/24/2014)
The 2014 BOL updates have lagged a bit and I suspect there are doc issues. There are 8 in 2014. If you see it documented as 4, please submit a bug.

OK, done that. Also added community content on the page.

edit: just checked: the page has been updated and is now correct, and the comm content I added is no longer there. But the bug is still "active".

Tom