Course Description
Point-in-time restores and geo replication are features used to protect SQL databases in an Azure implementation. This course introduces these features, as well as other features used for restoring databases and post recovery tasks.
Learning Objectives
SQL Database Data Recovery
- start the course
- recognize the factors that could impact recovery time to restore a database
- recognize how to implement a point-in-time restore
- demonstrate how to restore a deleted database to the point of deletion
- demonstrate how to restore a live database to a point in time
- design a geo-replication topology
- describe how standard geo-replication works
- configure active geo-replication
- implement active-passive compute with coupled failover
- implement active-passive compute with decoupled failover
- describe geo-restore features
- describe best practices for configuring your database after recovery
- demonstrate how to copy and export databases
- restore databases using PowerShell
Practice: SQL Database Recovery Features
- demonstrate how to use SQL database recovery features