Using Azure as an HA/DR site for SQL 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-45538%22%20slang%3D%22en-US%22%3EUsing%20Azure%20as%20an%20HA%2FDR%20site%20for%20SQL%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-45538%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wonder%20if%20anyone%20has%20dabbled%20with%20this%20concept%2C%20or%20if%20it%20is%20economically%20viable%20to%20my%20customer%2C%20which%20is%20a%20%22little%20big%20shop%22%20that%20would%20like%20to%20spend%20%24--%20for%20SQL%20HA%20and%2For%20DR%20(probably%20the%20latter%20is%20the%20only%20realistic%20cost-effective%26nbsp%3Bapproach%20across%20data%20centers%20that%20feature%20geodiversity).%20So%20I'd%20like%20to%20have%203%20on-premises%20instances%20replicate%20Async%20say%203-4x%2Fday%20(RPO%3D6-8%20hrs)%20to%20either%20IAAS%20instances%20that%20power%20on%20the%20same%203-4x%2Fday%20to%20receive%20replication%2C%20or%2C%20if%20SQL%20Azure%20supports%20AlwaysOn%2C%20use%20that%20for%20a%20%22target.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIdea%20would%20be%20to%20use%20this%20as%20a%20read%20only%20DR%20site%20in%20use%20cases%20ranging%20from%20extended%20power%20outages%20to%20cratered%20HQ.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnything%20in%20this%20scheme%20that%20might%20work%20with%20reasonably%20limited%20engineering%20effort%3F%20I%20don't%20want%20to%20add%20a%20ton%20of%20complexity%20or%20cost.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20or%20suggestions%20for%20reading%20will%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-111837%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Azure%20as%20an%20HA%2FDR%20site%20for%20SQL%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-111837%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EYou%20can%20use%20Azure%20as%20HA%2FDR%20that%20is%20the%20idea%20of%20the%20Hybrid%20infrastructure%20and%20SQL%202016%20supports%20that%20type%20of%20environment%2C%20of%20course%2C%20you%20will%20need%20to%20work%20on%20some%20items%20before%2C%20but%20this%20two%20docs%20online%20will%20help%20validate%20if%20your%20environment%20qualifies%20to%20implement%20this%20Hybrid%20scenario%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsqlclassic%2Fvirtual-machines-windows-classic-sql-onprem-availability%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsqlclassic%2Fvirtual-machines-windows-classic-sql-onprem-availability%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Favailability-groups%2Fwindows%2Fuse-the-add-azure-replica-wizard-sql-server%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Favailability-groups%2Fwindows%2Fuse-the-add-azure-replica-wizard-sql-server%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-46894%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Azure%20as%20an%20HA%2FDR%20site%20for%20SQL%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-46894%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fhh510230.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ein%20the%20book%20online%3C%2FA%3E%26nbsp%3B(under%20the%20title%20%22THIS%20TOPIC%20APPLIES%20TO%22)%20Always%20On%20Availability%20Groups%20does%20not%20supported%20in%20Azure%20SQL%20Databaseno%20or%20Azure%20SQL%20Data%20Warehouse%20(yet)%2C%20but%20you%20can%20still%20use%20Azure%20for%20your%20Disaster%20Recovery%20(DR).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-high-availability-dr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eyou%20can%20configure%20Always%20On%20availability%20group%20in%20Azure%20VM%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20you%20can%20use%20replication%20from%20local%20SQL%20to%20SQL%20Server%20Azure%20if%20you%20want%2C%20which%20is%20bery%20useful%20for%20lot%20of%20cases.%20For%20more%20information%20%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F36075.sql-azure-database-understanding-transactional-replication-step-by-step.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Echeck%20this%26nbsp%3Barticle%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Of%20course%20I%20cannot%20advise%20you%2C%20since%20I%20am%20not%20familiar%20with%20your%20system%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I wonder if anyone has dabbled with this concept, or if it is economically viable to my customer, which is a "little big shop" that would like to spend $-- for SQL HA and/or DR (probably the latter is the only realistic cost-effective approach across data centers that feature geodiversity). So I'd like to have 3 on-premises instances replicate Async say 3-4x/day (RPO=6-8 hrs) to either IAAS instances that power on the same 3-4x/day to receive replication, or, if SQL Azure supports AlwaysOn, use that for a "target."

 

Idea would be to use this as a read only DR site in use cases ranging from extended power outages to cratered HQ.

 

Anything in this scheme that might work with reasonably limited engineering effort? I don't want to add a ton of complexity or cost.

 

Any ideas or suggestions for reading will be appreciated.

2 Replies

Good day,

 

As you can see in the book online (under the title "THIS TOPIC APPLIES TO") Always On Availability Groups does not supported in Azure SQL Databaseno or Azure SQL Data Warehouse (yet), but you can still use Azure for your Disaster Recovery (DR).

 

For example, you can configure Always On availability group in Azure VM

 

In addition you can use replication from local SQL to SQL Server Azure if you want, which is bery useful for lot of cases. For more information check this article

 

* Of course I cannot advise you, since I am not familiar with your system

Hi,

You can use Azure as HA/DR that is the idea of the Hybrid infrastructure and SQL 2016 supports that type of environment, of course, you will need to work on some items before, but this two docs online will help validate if your environment qualifies to implement this Hybrid scenario:

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sqlclassic/virtual-machines-windows-...

 

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/use-the-add-azure-r...

 

Hope it works.