SQL Server Standard is undoubtedly one of the best selling editions due to its cost-effectiveness and feature sets. Its bigger sibling, the SQL Server Enterprise Edition is more than 3 times the cost. In most cases, only large companies can justify its cost benefits. Since a lot of existing and potential customers look for SQL Standard functionalities, in this post I am going to talk about how to replicate your data to an Azure VM with SQL Standard.
There are four main options for you to replicate your data to an Azure VM (Virtual Machine)
SQL Server Always On Availability Groups – Enterprise Features
IMPROVEMENTS ON HA & DR in SQL Server 2014 Enterprise
SQL Server introduces the basic tier of availability groups with some restrictions. However, there are no restrictions to replicate your data into an Azure VM. This expands HA and DR planning for SQL Server Standard Editions. Here are the highlights:
Standard Edition Specific Database Mirroring Features
Considerations before Implementing:
When Implementing Database Mirroring for Azure
You have 2 different options when you are doing On-Premises to Azure with Database Mirroring
Log shipping Options
Unlike Database Mirroring, You can maintain multiple secondary servers and enable Read-only operations on them. Optionally, you can add a Monitor server to monitor the entire deployment setup and check for errors. It also records history and status of backup/restore jobs. You can set up the monitoring server to raise alerts when jobs fail.
Considerations before Implementing Log-shipping
When Log-shipping is Used with Azure:
One server running in an Azure VM and the other running on-premises for cross-site disaster recovery. Log shipping depends on Windows file sharing, so a VPN connection between the Azure virtual network and the on-premise network.
Note: For successful disaster recovery of your databases, you should also install a replica domain controller at the disaster recovery site(Azure).
You have the options to either have an Azure SQL Database (PAAS) or a SQL Server on Azure VM.
Note: You can only use Azure SQL DB as a Subscriber to the Primary On-Premises Publisher Server.
The following versions & updates of SQL Server are required:
Comments are closed.