Authors:
- Provides a quick start to 24x7 availability in support of enterprise applications
- Helps database administrators ensure their ability to recover from data loss
- Covers the newly available support in AlwaysOn for the Linux operating system
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, log in via an institution to check for access.
Table of contents (10 chapters)
-
Front Matter
-
Back Matter
About this book
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both Windows and Linux operating systems. 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 and reliable. This edition is updated to account for all new major functionality and also includes coverage of implementing atypical configurations, such as clusterless and domain-independent Availability Groups, distributed Availability Groups, and implementing Availability Groups on Azure.
The book begins with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTOs), availability levels, and the cost of downtime. You’ll then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. Content includes coverage on implementing clusters, building AlwaysOn failover clustered instances, and configuring AlwaysOn Availability Groups.
SQL Server 2019 AlwaysOn is chock full of 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, as well as how to use AlwaysOn Availability Groups to scale-out read-only workloads. This is a practical and hands-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.
What You Will Learn
- Understand high availability and disaster recovery in SQL Server 2019
- Build and configure a Windows Cluster in Windows Server 2019
- Create and configure an AlwaysOn failover clustered instance
- Implement AlwaysOn Availability Groups and appropriately configure them
- Implement AlwaysOn Availability Groups on Linux servers
- Configure Availability Groups on Azure IaaS
- Administer AlwaysOn technologies post implementation
- Understand typical configurations, such as clusterless and distributed Availability Groups
Who This Book Is For
For Microsoft SQL Server database administrators who interested in growing their knowledge and skills in SQL Server’s high-availability and disaster recovery feature set.
Authors and Affiliations
-
Botley, UK
Peter A. Carter
About the author
Bibliographic Information
Book Title: SQL Server 2019 AlwaysOn
Book Subtitle: Supporting 24x7 Applications with Continuous Uptime
Authors: Peter A. Carter
DOI: https://doi.org/10.1007/978-1-4842-6479-9
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Peter A. Carter 2020
Softcover ISBN: 978-1-4842-6478-2Published: 12 November 2020
eBook ISBN: 978-1-4842-6479-9Published: 11 November 2020
Edition Number: 3
Number of Pages: XV, 267
Number of Illustrations: 116 b/w illustrations
Topics: Database Management, Microsoft and .NET