[Video] Configuring Geo-Replication to SQL DB

Published On: 2018-09-21By:

With the hurricane bearing down on the east coast of the United States last week, making sure you have a good disaster recovery plan in place should have been a top priority for you.  If you happen to be using Azure SQL DB, adding geo-replication is a simple and easy process.  On Friday of last week I posted a blog on how to configure asynchronous geo-replication however I do not think the post effectively explains on how easy it is to configure.

So, I created a video.  In less than 5 minutes, I show you how to configure geo-replication for a Azure SQL DB database.  In this video, you will see me geo-replicate my database from the East Coast of the United States to the West Coast.

Keep in mind that this video just shows a test database that has hardly any data in it.  If you had to replicate a larger database, it would take some time so planning would be important.  The sooner you start, however, the sooner you’ll have a copy of your database safely in another region.  Even with the risk of data loss in the event of a manual fail over, it might be better than being completely offline for hours, days, or even weeks.

It is worth mentioning that you will incur additional costs by having another copy of the database replicated in another region, but once the need has passed, you can remove the geo-replication and the secondary database.  That is one of the beautiful things about Azure, the ability to scale things up and down as needed.  Also, if you replicate to a different country, be cautious of their data privacy regulations.  Once you put data there, it might not be able to leave the country.

Enjoy the video and be sure to check back for more videos to come!  You can also subscribe to the Denny Cherry & Associates YouTube channel to watch videos from the entire team.

© 2018, John Morehouse. All rights reserved.

Contact the Author | Contact DCAC


Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award    FT Americas’ Fastest Growing Companies 2020   
Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link