Tuesday, November 8, 2011

SQL Server 2012 AlwaysOn Feature

When we think about availability and recovery concepts, we consider an individual database like log-shipping, replication, mirroring or an entire SQL Server instance i.e. failover clustering.
In SQL Server 2012, in addition to Failover Clustering development, we’ll be able to treat a group of databases as a unit. A much more common requirement with today’s complex, multi-datbase applications. This unit is called an Availability Group.

Availability Groups will allow us to fail over that group of databases as a single unit. A single instance of SQL Server can host multiple availability of groups, in the event of a failure;

we’ll have the flexibility to fail over one availability group to instance-1, another availability group to instance-2, and so on. This means that we don’t have to have a standby server that is capable of handling the full load of our primary server, we can distribute those workloads across multiple servers, lower powered servers, with the same application-transparency like traditional mirroring today.

We will also be able to have more than a single replica for each Availability Group, so we can have one or more local copies as well as one or more remote copies.

Finally, read-only secondary’s will allow us to run certain backup operations and all reporting activity against the mirrored copy, taking significant load off the primary server.

NOTE: AlwaysOn is not a technology it is merely the branding for the high availability and disaster recovery features in SQL Server.
High Availability. SQL Server AlwaysOn. SQL Server 2012. Quickly Setup SQL Server AlwaysOn Failover Cluster Instance. Encrypting Your SQL Server 2012 AlwaysOn Availability Databases. Planning for SQL Server 2012 AlwaysOn Availability Groups. Microsoft SQL Server AlwaysOn Solutions. AlwaysOn Availability Group Setup. sql server alwayson availability groups. sql server alwayson backup. sql server alwayson active secondaries. sql server alwayson failover cluster instances. sql server alwayson team blog microsoft. alwayson availability group blog.


Post a Comment