Home Cloud Computing Microsoft Azure SQL Databases Disaster Recovery 101

Microsoft Azure SQL Databases Disaster Recovery 101

Microsoft Azure SQL Databases Disaster Recovery 101

Why should I care? As a PaaS service, Azure SQL provides automated backup for all databases. It allows customers to recover their data from system or human errors and restores the databases to any point in time during the retention. But it won’t guarantee that your data will be always available, in some extreme cases. Imagine aliens invaded one of our data centers and destroyed everything, or more realistically, extreme weather put the whole area in power outage. Look at what hurricane Irma or Marina did. It happens.

Fortunately, Azure DB is prepared for this. We provide not only one, but two different solutions to recover your data in those disasters: Geo Restore and Geo Replication.

You will learn the followings in the next 5 minutes:

  • What do these features do?
  • What is the difference between these two?
  • How do I choose between these two?

If you already have answer for these questions or want to learn more details about the Azure DB business continuity and disaster recovery, please refer to our online documentation.

What do these features do? Geo Restore allows customers to recover the database to a different region from backup. The automated backup of all Azure databases is replicated to a secondary region in background. Geo Restore always restore the database from the copy of backup files stored in the secondary region.

Geo Replication will create a continuous copy of your database in one or more secondary region(s) (up to 4 secondary replicas). In event of disaster, you can simply failover to one of the secondary region and bring you database back online. You can also configure failover group to recover the databases automatically.

Read the entire article here, Azure SQL Databases Disaster Recovery 101 | Blog

Via the fine folks at Microsoft.


Founded in 1975, Microsoft (Nasdaq “MSFT”) is the worldwide leader in software, services, devices and solutions that help people and businesses realize their full potential.

Share your view, leave a comment below:

Featured Resources:

Related Articles:


White Papers


      On-Demand Webinars

        Latest Videos

          Views All IT News on DABCC.com
          Views All IT Videos on DABCC.com
          Register Today for Disrupt End User Computing Forum 2018

          Visit Our Sponsors