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