Chapter 5: Working with Disaster Recovery Options

High availability (HA) and disaster recovery (DR) are important solutions for an enterprise strategy concerned with data availability. SQL Server has several different features available for implementing HA and DR scenarios. These will help you increase the availability metric of your SQL Server environment and the applications that are using the data stored on SQL Server.

High availability and disaster recovery are frequently mixed up as many people think they are the same; however, they are not. HA helps you eliminate a single point of failure and provides features and services to keep your environment online, even in case of an incident. DR, on the other hand, is a process you would use to ...

Get SQL Server 2019 Administrator's Guide - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.