sqlrus.com
Steps for SQL DB Geo Replication | John Morehouse
Unless you are living under a rock, you have most likely heard of the hurricane that is bearing down on the east coast of the United States. Some areas have mandatory evacuation and I have seen reports of 80' plus foot waves so this hurricane is not a joke. Another item that should not be a joke is a disaster recovery plan. This is a vital and critical plan that every organization should have in place. If you do not have a plan in place, you are asking for events, like a hurricane, to potentially force your business to close its doors for days or even weeks on end. However, if you are utilizing SQL DB in Azure, you can easily configure a quick and dirty DR plan to get you through the rough times. While it might not be an automatic failover (I'll blog about that later), it is better than nothing and it just might save your business. Let's take a look. Azure Portal Looking in the portal, I've got an Azure database, Test1, that is residing in the East US region. This is just a Basic