Related Articles
Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.


-1.png)
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Classes
Private deliveries of courses for groups
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Certification Training
Prepare and ace your next certification with CertXP.
Cheat Sheets
Quick references for when you need a little guidance.
Prag Guides
Explore our knowledge base for quick tips on syntax, functions, and more!
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Quickstarts
Hands-on training with expert-led collaborative development.
Private Training
Personalized approach for your specific training requirements
Hackathons
Use your own data to take your team's skills to the next level.
Virtual mentoring
Get there faster with your personal trainer.
Enablement
Comprehensive enterprise enablement training for your team.
Admin Hackathon
Tame your power platform environment.
What is your disaster recovery plan for your Azure SQL Data Warehouse? Today I’d like to talk about disaster recovery in Azure SQL Data Warehouse, more specifically, about a feature that was released with Azure SQL Data Warehouse Gen2 called Geo-backup policy.
The image below shows my configuration of an Azure SQL Data Warehouse. I have a menu shown here for the Geo-backup policy and you’ll see my selection says it’s enabled but I don’t have the choice of turning it on and off. In Gen2 this is turned on by default and cannot be turned off.
If you’re using Gen1, although it is turned on by default so the Geo-backup policy is enabled automatically, you can opt out of this feature unlike Gen2.
What Geo-backup policy does is it automatically creates backups of our Azure SQL Data Warehouse to store in a different region or in a region other than where our data warehouse is hosted. This means my backups are automatically taken and stored in the other region in a region pair.
Microsoft has created these region pairings so if I have a data warehouse hosted, for example, in East US, then the Geo-backups will be taken and stored in the West US. A partial list of the region pairings is below; you can view the full list on Microsoft’s website.
The regions in a pair are generally more than 300 miles apart from each other with the idea being that any outage impacting your home region should not impact the Geo-backup region. A few more interesting points about Geo-backups:
The Geo-backup policy as part of Azure SQL Data Warehouse Gen2 is an interesting feature and can be very helpful. If you have questions about this feature, disaster recovery in Azure, Azure SQL Data Warehouse or anything Azure related, we’d love to help. Our knowledge and expertise of Azure products and services can help you take your business from good to great. Click the link below or contact us.
ABOUT THE AUTHOR
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment