Practitioner Level

Design for DR and HA in Azure SQL Database

Pricing
45 minutes
  • 3 Learning Objectives

About this Hands-on Lab

In this lab we will be designing a SQL Database instance to take advantage of High Availability and Disaster Recovery. This lab will include a review of LTR and scaling out with geographic regions.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create SQL Databases

For the first task we need to create 2 SQL Databases with Standard 10 DTUs in the East US region.

Configure a Failover Group for Both Databases

We will then configure Active Geo Replication for 1 database and a failover group for both databases in the West US server. The failover group should have a secondary SQL server in West US as the failover option with East being primary.

Configure Long Term Backups for both Databases

The backups for both databases should be weekly backups stored for 2 years and monthly backups should be configured and stored for 4 years. Daily backups will be handled by the default backups provided for in SQL DB. Create an LTR in both West and East servers.

Contact SalesSee Pricing

Additional Resources

Scenario

Your company has recently become concerned about its growing data footprint. It would like to implement high availability to minimize the risk of downtime and would like to implement a disaster recovery solution to provide additional protection from failed code implementations, outages, and other unforeseen issues.

You have been asked to implement a solution that meets the following requirements:

  • It provides High Availability
  • It provides disaster recovery for all databases from East US to West US (East being primary)
  • It has backups created and stored on a daily, weekly, and yearly basis. All weekly and yearly backups should be stored for 2 and 4 years respectively. Daily backups should be available for short term restoration.

Instructions

  • Log in to the live environment with the provided Azure Labs credentials.
  • Create 2 SQL Databases
    • (x2) Standard 10 DTUs ○ SQL Server test12353 ○ East US region
  • Configure Active Geo Replication to West US for 1 database
  • Configure a failover group for both databases to West US
  • Configure retention for both databases in the West US and East servers
    • Weekly LTR backups for 2 years and Monthly LTR backups for 4 years

For detailed instructions on how to complete these tasks, expand each learning objective below, or click the Guide tab above the video player.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Don't have an account?

Get Started
Who’s going to be learning?
MyselfMy Organization