Linked e-resources
Details
Table of Contents
At a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Part I: Getting Started; Chapter 1: High Availability and Disaster Recovery Concepts; What Is High Availability?; Calculating Availability; Causes of Downtime; What Is Disaster Recovery?; Recovery Objectives; Planning for Disaster Recovery; Summary; Chapter 2: Introduction to Always On; Common Solutions before Always On; Failover Cluster Instances (FCI); Database Mirroring; Log Shipping; Replication; Limitations and Concerns; What Is Always On?; SQL Server 2014; SQL Server 2016; Summary
Part II: Planning Always On Availability GroupsChapter 3: Concepts and Common Topologies; Availability Group Concepts; Availability Group and Replicas; Availability Group Listener; Availability Mode; Failover and Failover Modes; Common Topologies; Stand-alone to Stand-alone; SQL Failover Clustered Instance (FCI) to Stand-alone and Vice Versa; SQL FCI to SQL FCI; Extend On-Premises Always On Availability Groups to Microsoft Azure; Always On Availability Groups in Azure Virtual Machines (VMs); Distributed Availability Groups; Summary; Chapter 4: Data Synchronization Internals
Trade-offs and Opportunity CostSynchronous-Commit Mode; Asynchronous-Commit Mode; Synchronization Behavior in Various Scenarios; Scenario 1: Secondary Replica Goes Offline; How Does a Synchronous Secondary Replica Resynchronize with the Primary Replica?; How Does an Asynchronous Secondary Replica Resynchronize with the Primary Replica?; Scenario 2: Primary Replica Goes Offline; Automatic Failover Sequence of Actions; Planned Manual Failover Sequence of Actions; Forced Failover Sequence of Actions; How a Forced Failover Can Cause Data Loss; Summary
Chapter 5: Introduction to Windows Server Failover ClusteringOverview of a Failover Cluster; Cluster Node; Networks; Cluster Resource; Resource Dependency; Role; Failover; Failback; Preferred Owner; Possible Owner; Heartbeat; Quorum; Dynamic Quorum; Dynamic Witness; Benefits and Limitations of Failover Cluster; Summary; Chapter 6: Prerequisites; Windows Requirements; Recommendations; SQL Server Instance Requirements; Availability Database Requirements; Availability Group Interoperability; Summary; Part III: Deploying Always On Availability Groups
Chapter 7: Create a Windows Server Failover ClusterCreate a Windows Server Failover Cluster Using Failover Cluster Manager; Step 1: Install Failover Clustering Feature; Open Add Roles and Features Wizard; Select Installation Type; Select the Servers; Select Failover Clustering Feature; Confirm Installation Selections; Step 2: Validate Failover Cluster; Open Cluster Validation Wizard; Select Servers or a Cluster; Select Testing Options; Confirm Selections; Review Report; Step 3: Create Windows Server Failover Cluster; Open Create Cluster Wizard; Select Servers
Part II: Planning Always On Availability GroupsChapter 3: Concepts and Common Topologies; Availability Group Concepts; Availability Group and Replicas; Availability Group Listener; Availability Mode; Failover and Failover Modes; Common Topologies; Stand-alone to Stand-alone; SQL Failover Clustered Instance (FCI) to Stand-alone and Vice Versa; SQL FCI to SQL FCI; Extend On-Premises Always On Availability Groups to Microsoft Azure; Always On Availability Groups in Azure Virtual Machines (VMs); Distributed Availability Groups; Summary; Chapter 4: Data Synchronization Internals
Trade-offs and Opportunity CostSynchronous-Commit Mode; Asynchronous-Commit Mode; Synchronization Behavior in Various Scenarios; Scenario 1: Secondary Replica Goes Offline; How Does a Synchronous Secondary Replica Resynchronize with the Primary Replica?; How Does an Asynchronous Secondary Replica Resynchronize with the Primary Replica?; Scenario 2: Primary Replica Goes Offline; Automatic Failover Sequence of Actions; Planned Manual Failover Sequence of Actions; Forced Failover Sequence of Actions; How a Forced Failover Can Cause Data Loss; Summary
Chapter 5: Introduction to Windows Server Failover ClusteringOverview of a Failover Cluster; Cluster Node; Networks; Cluster Resource; Resource Dependency; Role; Failover; Failback; Preferred Owner; Possible Owner; Heartbeat; Quorum; Dynamic Quorum; Dynamic Witness; Benefits and Limitations of Failover Cluster; Summary; Chapter 6: Prerequisites; Windows Requirements; Recommendations; SQL Server Instance Requirements; Availability Database Requirements; Availability Group Interoperability; Summary; Part III: Deploying Always On Availability Groups
Chapter 7: Create a Windows Server Failover ClusterCreate a Windows Server Failover Cluster Using Failover Cluster Manager; Step 1: Install Failover Clustering Feature; Open Add Roles and Features Wizard; Select Installation Type; Select the Servers; Select Failover Clustering Feature; Confirm Installation Selections; Step 2: Validate Failover Cluster; Open Cluster Validation Wizard; Select Servers or a Cluster; Select Testing Options; Confirm Selections; Review Report; Step 3: Create Windows Server Failover Cluster; Open Create Cluster Wizard; Select Servers