SQLShorts : AlwaysOn SQL 2012

Play SQLShorts : AlwaysOn SQL 2012
Sign in to queue


From MSDN:

The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in Microsoft SQL Server 2012. AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. Deploying AlwaysOn Availability Groups involves creating and configuring one or more availability groups. Each availability group is a container for a discrete set of user databases, known as availability databases, that fail over together. An availability group can have multiple possible failover targets (secondary replicas). Moreover, you can configure secondary replicas to support read-only access to secondary databases and for performing backups on secondary databases.


High Availability (Windows Cluster) + Disaster Recovery (Mirroring)

Primary + 4 secondaries

1 automatic failover pair

2 synchronous

2 asynchronous

Can place multiple nodes & databases in Availability Groups

Can do backup and reporting off secondaries

Availability Groups support Virtual names

Built in compression and encryption

Windows Server Core supported

Multi-site clustering across subnets

Support for network attached storage




Download this episode

The Discussion

Add Your 2 Cents