Concepts and Common Topologies

  • Uttam Parui
  • Vivek Sanil
Chapter

Abstract

Always On Availability Groups (AGs) provide the best in class and cost-effective, high availability (HA) and disaster recovery (DR) solutions for on-premises and cloud applications. Availability group solutions are significantly improved as compared to previous SQL Server solutions like database mirroring and log shipping. It provides an integrated set of options, including automatic and manual failover of a group of databases, multiple secondaries, active secondaries, fast application failover, and automatic page repair.

Keywords

Shipping 

Copyright information

© Uttam Parui and Vivek Sanil 2016

Authors and Affiliations

  • Uttam Parui
    • 1
  • Vivek Sanil
    • 2
  1. 1.MooresvilleUSA
  2. 2.San AntonioUSA

Personalised recommendations