Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
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.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
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.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.