What’s New in SQL Server AlwaysOn and Availability Groups

Now, with a couple of years under their belt with these features, Microsoft is starting to open up several of the previously tight limitations such as the number of secondaries allowed.

Image You can use AlwaysOn and availability groups with complex data managed through FILESTREAM, even when using Remote Blog Storage and FileTable.

Image Up to 8 secondary replicas can be defined for any one availability group. This used to be 4 secondary replicas max.

There can be up to 3 Synchronous Commit replicas. ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.