Azure SQL High Availability and Disaster Recovery
Thinking about how to leverage the HA and DR options for Azure SQL services.
🔎 Looking for content on a particular topic? Search the channel. If I have something it will be there!
▬▬▬▬▬▬ C H A P T E R S ⏰ ▬▬▬▬▬▬
00:00 – Introduction
00:23 – High availability
07:34 – HA RPO and RTO and client retry
11:16 – Availability Zones
13:48 – Server and databases
15:48 – Disaster Recovery
20:47 – Automatic failover groups
23:05 – Geo-replication
24:11 – Replication technology
26:36 – Forget AUTOMATIC
28:29 – DR RPO and RTO
31:36 – Performing a failover
33:40 – Let DNS do its job
34:30 – Planned and unplanned
37:44 – How to implement DR failover process
42:52 – Listener
47:22 – Summary
49:15 – Close
▬▬▬▬▬▬ K E Y L I N K S 🔗 ▬▬▬▬▬▬
► Whiteboard:
🔗 https://github.com/johnthebrit/RandomStuff/raw/master/Whiteboards/AzureSQLDR.png
► Microsoft latency numbers:
🔗 https://learn.microsoft.com/azure/networking/azure-network-latency?tabs=Americas%2CWestUS
► Microsoft RPO and RTO numbers:
🔗 https://learn.microsoft.com/azure/azure-sql/database/business-continuity-high-availability-disaster-recover-hadr-overview?view=azuresql#recover-a-database-to-the-existing-server
▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬
📖 Recommended Learning Path for Azure
🔗 https://learn.onboardtoazure.com
🥇 Certification Content Repository
🔗 https://github.com/johnthebrit/CertificationMaterials
📅 Weekly Azure Update
🔗 https://youtube.com/playlist?list=PLlVtbbG169nEv7jSfOVmQGRp9wAoAM0Ks
☁ Azure Master Class
🔗 https://youtube.com/playlist?list=PLlVtbbG169nGccbp8VSpAozu3w9xSQJoY
⚙ DevOps Master Class
🔗 https://youtube.com/playlist?list=PLlVtbbG169nFr8RzQ4GIxUEznpNR53ERq
💻 PowerShell Master Class
🔗 https://youtube.com/playlist?list=PLlVtbbG169nFq_hR7FcMYg32xsSAObuq8
🎓 Certification Cram Videos
🔗 https://youtube.com/playlist?list=PLlVtbbG169nHz2qfLvPsAz9CnnXofhmcA
🧠 Mentoring Content
🔗 https://youtube.com/playlist?list=PLlVtbbG169nGHxNkSWB0PjzZHwZ0BkXZZ
❔ Questions? Maybe I answered it in my FAQ
🔗 https://savilltech.com/faq
👕 Cure Childhood Cancer Charity T-Shirt Channel Store
🔗 https://johns-t-shirts-store.creator-spring.com/
👂 Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings! https://youtu.be/v5b53-PgEmI for a demo of using this feature.
SUBSCRIBE ✅ https://www.youtube.com/channel/UCpIn7ox7j7bH_OFj7tYouOQ?sub_confirmation=1
#microsoft #azure #johnsavillstechnicaltraining #onboardtoazure #cloud
source by John Savill’s Technical Training
windows server dns
Let's dive into the HA and DR for Azure SQL services! Please make sure to read the description for the chapters and key information about this video and others.
⚠ P L E A S E N O T E ⚠
🔎 If you are looking for content on a particular topic search the channel. If I have something it will be there!
🕰 I don't discuss future content nor take requests for future content so please don't ask 😇
🤔 Due to the channel growth and number of people wanting help I no longer can answer or even read questions and they will just stay in the moderation queue never to be seen so please post questions to other sites like Reddit, Microsoft Community Hub etc.
👂 Translate the captions to your native language via the auto-translate feature in settings! https://youtu.be/v5b53-PgEmI for a demo of using this feature.
Thanks for watching!
🤙
Thank you for all the great stuff you post for us sir! Most of my Azure team colleagues watch you regurarly and you became an absolute legend there 👍. Everytime I watch some non-Savill Azure content I realize how gifted you are in presenting and explaining. By far the best technical channel I`ve seen. Wishing you all the best!!
A great refresher for things I thought I already knew but didn't. Thank you for your amazing content.
I love the way you are able to inject humor into such "serious topic", John 😆. Great video, as always.
Thanks for this John! Great coverage of the HA and DR options for the SQL services.
Thanks for the great explanation, John! I had a good laugh at "Where did my datacenter go?" 🤣
Thank you john, amazing videos❤
Great Video and thanks for sharing all your thoughts! Really appreciate all the effort you put into making thinks so easy to understand !
Thx John, great explanation. CU Friday. Have a great week.
Awesome Explanation 👍👍👍👍👍👍
Loved this so much! Amazing content. 💯💯💯
Whoa this is a deep dive I'm looking forward to. Thanks much.