Using ActiveDR with Microsoft SQL Server

Microsoft Platform Guide

Audience
Public
Source Type
Documentation

As data volumes continue to grow, database administrators who manage Microsoft SQL Server can find it difficult to protect their organizations against data loss. Traditional disaster recovery methods can be time-consuming and can negatively impact recovery time objectives and recovery point objectives for applications with sensitive service-level agreements. As a result, hardware failures, ransomware attacks, and disaster scenarios can lead to costly downtime.

The Everpure® FlashArray™ solution helps database and storage administrators create comprehensive disaster recovery strategies with the ActiveDR™ feature. This FlashArray feature provides continuous replication and a near-zero recovery point objective across geographically dispersed data centers. ActiveDR also simplifies disaster recovery workflows such as non-disruptive failover testing, live failovers, and failbacks.

How to Use This Document

This white paper provides an overview of ActiveDR and how to use it with SQL Server. It is intended for database administrators, storage administrators, and database reliability engineers who use SQL Server and FlashArray systems within the same data center, or across multiple geographically-dispersed data centers. This white paper discusses the benefits ActiveDR provides to database and storage administrators, while giving technical details on how to configure ActiveDR for use with SQL Server.