| Document Type
|
:
|
BL
|
| Record Number
|
:
|
602282
|
| Doc. No
|
:
|
b431501
|
| Main Entry
|
:
|
Parui, Uttam
|
| Title & Author
|
:
|
Pro SQL server always on availability groups : : enterprise-level high-availability and disaster recovery /\ Uttam Parui, Vivek Sanil
|
| Page. NO
|
:
|
1 online resource (316 pages)
|
| ISBN
|
:
|
1484220714
|
|
|
:
|
: 9781484220719
|
|
|
:
|
1484220706
|
|
|
:
|
9781484220702
|
| Notes
|
:
|
Includes index
|
| 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
|
|
|
:
|
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
|
| Abstract
|
:
|
With a focus on real-world experiences and war stories, this book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups, and shows how to reduce downtime, maximize application availability, and provide data protection. --
|
| Subject
|
:
|
Computer software-- Reusability
|
| Subject
|
:
|
Database management
|
| LC Classification
|
:
|
QA76.9.C55
|
| Added Entry
|
:
|
Sanil, Vivek
|
| Added Entry
|
:
|
Ohio Library and Information Network
|