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:
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.
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
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
Starting at $0.55 an hour per instance
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.
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.
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.
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.
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