Updated: July 14, 2020 (February 17, 2014)

SQL Server 2014 Improves Replication, High-Availability

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server 2014 improves the AlwaysOn Availability Groups (AG) feature introduced in SQL Server 2012 that replicates databases to redundant servers with support for in-memory tables and replication to Windows Azure virtual machines. AlwaysOn AG uses replication to increase server availability, speed disaster recovery, and provide optimized read-only access for reporting and business intelligence tools. However, configuring the environment for optimum performance, resolving limitations replicating some SQL Server services, and connecting to cloud backups requires careful planning.

SQL Server Delivers AlwaysOn

AlwaysOn AG is a SQL Server 2012 and SQL Server 2014 feature that simplifies the configuration and deployment of high availability and disaster recovery services and enables the use of replicated databases for backup and reporting services.

High Availability and Disaster Recovery

Ideally, a database environment and associated applications are designed to deliver high availability, as well as disaster recovery, with minimal data loss should a failover occur. SQL Server technologies address these requirements as follows:

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now