SQL Server AlwaysOn and Availability Groups

Typical use cases (scenarios) for AlwaysOn and availability groups include the following:

Image Need for High Availability nearing five-nines (99.999% available). This means that your database layer must be super resilient to failure and have nearly no data loss in the case of failure.

Image You have disaster recovery (DR) needs that need to replicate data to another site (perhaps on the other side of the country or planet), but you can tolerate a little bit of data loss (and data latency).

You have a performance ...

Get Microsoft® SQL Server 2012 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.