SQL Server High Availability and Disaster Recovery (HADR)

Microsoft SQL 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 a SQL high availability and disaster recovery solution. Our hosted solution, combined with Microsoft Azure, 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.

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

Data sovereignty with geo-replicated off-site storage

Familiar tools used across a common platform

Pricing

Pricing will vary based on the number of SQL instances. Suggested pricing per instance will be based on the guidelines below. Please inquire for further pricing information to Account Manager

SQL HADA Solution Accelerator.

With our azure certified SQL HADR Solution, we can deploy a custom solution within 2 to 4 weeks - On-premise, Azure or another cloud provider such as AWS

Hosted Server Licensing

Starting at $0.55 an hour per instance

+

Support

Baseline pricing above assumes Windows Server Instance (memory intensive) with 100 Gb out-bound data transfer and 100 Gb data a month. SQL Ent volume licensing with SA (BYOL) required or use SQL Ent Server instance.

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.

Automatic log shipping with Azure Virtual Machines

Azure Virtual Machines also enables automatic backup of transaction logs from a primary database instance to a separate secondary database instance of SQL Server 2008 R2, as shown in Figure 3. This allows you to offer an optional third server instance that monitors log shipping operations, records the history and status of backup and restore operations, and optionally raises alerts if a scheduled operation fails to occur. This feature supports limited read-only access to secondary databases between operations.

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

Requirements gathering (mobile data compliance policies, required mobile applications and intellectual property to protect, service level agreements, communication plans)

End-to-end project management for the duration of the engagement defined in the requirements gathering

Creation and migration/replication of all designated instances

Additional service add-ons

  • Service management (datacenter monitoring, technical support/SLA)
  • Communication and customer management
  • Customized SEEPATH private cloud options (geo, configurations)

Basic architecture

Microsoft SQL Server HADR is a highly available and resilient offering powered by Microsoft Azure and managed by us, providing a comprehensive solution to manage workloads.

Figure 1: AlwaysOn Availability Groups

Figure 2: Database mirroring

Figure 3: Log shipping

Figure 4: Backup and restore with Azure Blob Storage