[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.

Video

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.