Tagline: Supporting 24 x 7 Operations with continuous uptime
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable.
Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization.
SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.
Teaches you to build HA and DR solutions using the AlwaysOn feature set Provides real-world advice on configuration and performance considerations Demonstrates administrative techniques for the AlwaysOn feature set What You Will Learn
Understand high availability and disaster recovery in SQL Server 2016 Build and configure a Windows Cluster Create and configure an AlwaysOn failover clustered instance Implement AlwaysOn Availability Groups and appropriately configure themAdminister AlwaysOn technologies post implementationTroubleshoot and resolve problems with misbehaving systems Who This Book Is For
Database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.
Covers a new and high-end feature set that is sweeping the user community
Provides a quick start to 24x7 availability in support of enterprise applications
Helps database administrators ensure their ability to recover from data loss
AlwaysOn is of interest to any database administrator looking to support 24x7 availability of production systems. Such high-availability is increasingly considered to be the default requirement in enterprise-level and Internet-based applications. AlwaysOn is a relatively new feature introduced in the SQL Server 2012 release, enhanced in 2016, and this book covers those latest enhancements in the 2016 edition. The relative newness of AlwaysOn combined with the increasing demand for 24x7 operatinons contributes to the demand for this book that helps database administrators quickly get to grips with an increasingly important feature that is the foundation of SQL Server’s support for high-availability and disaster recovery.
Peter A. Carter
24x7 Always On AlwaysOn Availability Groups Disaster Recovery Failover Failover Cluster High-Availability Log Shipping Mirroring Recovery Point Objectives Recovery Time Objectives SQL Server Standby Standby Server