更新时间:2021-06-11 13:30:56
封面
版权页
Preface
About the Book
Lesson 1 Getting Started with SQL Server HA and DR
Introduction
What is High Availability and Disaster Recovery?
HA and DR Terminologies
SQL Server HA and DR Solutions
Introduction to SQL Server Replication
Types of Replication
Configuring Snapshot Replication Using SQL Server Management Studio
Optimizing Snapshot Replication
Summary
Lesson 2 Transactional Replication
Understanding Transactional Replication
Configuring Transactional Replication
Azure SQL Database as a Subscriber in Transaction Replication
Understanding Peer-To-Peer Transactional Replication
Configuring Peer-To-Peer Transactional Replication
Modifying an Existing Publication
Lesson 3 Monitoring Transactional Replication
The Replication Monitor
Real-World Transactional Replication Problems and Solutions
Conflicts in Peer-to-Peer Transactional Replication
Lesson 4 AlwaysOn Availability Groups
AlwaysOn Availability Group Concepts and Terminology
AlwaysOn Availability Groups
Creating Hyper-V VMs
Active Directory Domain Controller
Installing the SQL Server Developer Edition
Windows Server Failover Cluster
Configuring AlwaysOn Availability Groups
AlwaysOn Availability Groups on Microsoft Azure
Lesson 5 Managing AlwaysOn Availability Groups
AlwaysOn AG Failover
Managing AlwaysOn Availability Groups
Monitoring AlwaysOn Availability Groups
Troubleshooting AlwaysOn Availability Groups
Lesson 6 Configuring and Managing Log Shipping
Configuring Log Shipping
Managing and Monitoring Log Shipping
Troubleshooting Common Log Shipping Issues
Comparing AlwaysOn Replication and Log Shipping
Appendix
Lesson 1: Getting Started with SQL Server HA and DR
Lesson 2: Transactional Replication
Lesson 3: Monitoring Transactional Replication
Lesson 5: Managing AlwaysOn Availability Groups
Lesson 6: Configuring and Managing Log Shipping