Home Page Icon
Home Page
Table of Contents for
Dedication
Close
Dedication
by Peter A Carter
SQL Server AlwaysOn Revealed
Cover
Title
Copyright
Dedication
Contents at a glance
Contents
About the Author
About the Technical Reviewers
Chapter 1: High Availability and Disaster Recovery Concepts
Level of Availability
Service-Level Agreements and Service-Level Objectives
Proactive Maintenance
Recovery Point Objective and Recovery Time Objective
Cost of Downtime
Classification of Standby Servers
Summary
Chapter 2: Understanding High Availability and Disaster Recovery Technologies
AlwaysOn Failover Clustering
Active/Active Configuration
Three-Plus Node Configurations
Quorum
Database Mirroring
AlwaysOn Availability Groups
Automatic Page Repair
Log Shipping
Recovery Modes
Remote Monitor Server
Combining Technologies
Summary
Chapter 3: Implementing a Cluster
Building the Cluster
Installing the Failover Cluster Feature
Creating the Cluster
Configuring the Cluster
Changing the Quorum
Configuring MSDTC
Configuring a Role
Summary
Chapter 4: Implementing an AlwaysOn Failover Clustered Instance
Building the Instance
Preparation Steps
Cluster-Specific Steps
Installing the Instance with PowerShell
Adding a Node
Summary
Chapter 5: Implementing AlwaysOn Availability Groups
Implementing High Availability with AlwaysOn Availability Groups
Configuring SQL Server
Creating the Availability Group
Performance Considerations for Synchronous Commit Mode
Implementing Disaster Recovery with Availability Group
Configuring the Cluster
Configuring the Availability Group
Adding AlwaysOn Readable Secondary Replicas
Summary
Chapter 6: Administering AlwaysOn
Managing a Cluster
Moving the Instance between Nodes
Removing a Node from the Cluster
Managing AlwaysOn Availability Groups
Failover
Synchronizing Uncontained Objects
Monitoring
Adding Multiple Listeners
Other Administrative Considerations
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Copyright
Next
Next Chapter
Contents at a glance
This book is dedicated to the beloved memory of Margaret Carter (1938-2015)
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset