Recovering SQL Databases


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


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

Target Audience
Database professionals interested in working with hybrid/cloud solutions, and individuals who are preparing to take the 70-473 exam

Prerequisites
None

Expected Duration (hours)
1.2

Lesson Objectives

Recovering SQL Databases

  • 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
  • demonstrate how to use SQL database recovery features

    • Course Number:
    cl_dicp_a10_it_enus

    Expertise Level
    Expert