SQL Alwayson High-availability and Disaster Recovery (HADR)


Enable high availability and business continuity for business-critical data stored in SQL Server. Protect your business from costly downtime.

Why Microsoft SQL High Availability Disaster Recovery (HADR)?

As an IT decision maker, it is vitally important to understand the level of SQL protection your organization needs. The following criteria can help determine your best option:

  • Recovery time objectives (RTOs)

  • Recovery point objectives (RPOs)

  • Hardware and software costs

  • Ease of use

Our custom Microsoft SQL Server HADR solution is a cost-effective way to quickly implement and enable SQL high availability and disaster recovery. Our hosted solution, combined with Microsoft Azure platform, provides the most complete HADR package. By using Microsoft Azure virtual machines (VMs) with SQL Server, we can help lower the cost of an HADR database solution.

Our always-on managed SQL HADR solution can be deployed on Azure, AWS, or in a hybrid environment

Benefits

Our certified SQL Server HADR provides you with the following benefits:

Reduced operational expenses with shift to cloud storage

New high availability and disaster recovery options

Ability to quickly and inexpensively test a high availability and disaster recovery solution

Reduced data loss (RPO) and increased speed of recovery (RTO) with premium service level agreements

What's included?

You can enable up-scale high availability and disaster recovery offers with breakthrough performance, availability, and manageability for your customers’ mission-critical applications.

The cost of downtime is significant to businesses of all sizes. Having the ability to provide disaster recovery and business continuity solutions, specifically for business-critical data stored in SQL Server, allows you to fulfill important business needs.

Disaster recovery with SQL Server AlwaysOn in the cloud

One of our most powerful hybrid scenarios, the low RTO disaster recovery solution for your on-premises SQL Servers, is now even easier to implement with SQL Server 2014. You can simply add SQL Server AlwaysOn replicas directly to Microsoft Azure Virtual Machines. As you see in Figure 1, we recommend having your asynchronous replicas residing in Azure Virtual Machines and your synchronous replica hosted in the same location. This helps minimize impact on your primary, and having the synchronous close by is ideal. Data loss is minimal in this low RTO solution, since the asynchronous replication is on its way to the replica in Azure just as soon as the transaction is committed.

The other big gain in this scenario is that AlwaysOn replicas are readable, so you can take advantage of the global Azure datacenter to strategically place the replicas (you can now have up to eight replicas with SQL Server 2014, twice as many as with SQL Server 2012). This means faster global business-intelligence reporting, in addition to a more cost-effective disaster recovery solution.

We have also built a helpful user interface into SQL Server management studio to make the deployment of AlwaysOn replicas even easier, regardless of hosting location.

High availability and disaster recovery with SQL Server Availability Groups and Windows Server Clustering

You can extend high availability and disaster recovery capabilities to your datacenter with Windows Server 2012 Clustering and SQL Server 2014 AlwaysOn Availability Groups. Implement a premium quality-of-service (QoS) disaster recovery solution that offers high availability and geo-replication, while addressing RTO, RPO, and customer data sovereignty requirements through Windows Server 2012 Failover Clustering and SQL Server AlwaysOn Availability Groups.

Data backup and restore with Azure Blob Storage

You can also provide a low-cost backup solution with additional storage through geo-replication. A single cloud backup strategy covers all SQL Server instances with the Microsoft SQL Server Backup to Microsoft Azure Tool. You can reduce operational expenditures by shifting to the scalable, security-enhanced, and cost-effective Azure Blob Storage service shown in Figure 4. This lets you protect data through the durable Azure platform with compression and auto-encryption.

We will work with you on the following items through the offering lifecycle:

Requirements gathering (Review existing scenario, pain-points, HA and DR requirements)

Choose the right HADR deployment architecture based on Azure, hybrid and/or multi-cloud scenario

Implement SQL AG, listener and Cluster networks for primary and DR regions

Run test fail-over scenarios

Automatic, Planned and Forced failover scenarios to validate high-availability and DR functionality

Seepath SQL architects can help you design and deliver a SQL Server high availability solution on Azure, AWS or in a hybrid environments.

Get started with our managed SQL HADR solutions today and make the most of your SQL and hybrid cloud investments.