From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Learning objectives

Learning objectives

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Learning objectives

“

- Welcome back. This is lesson 14, plan and perform backup and restore of a database. In this lesson, we will apply what we learned in the previous lesson regarding recovery point, objectives, and recovery time objectives in the context of database backup and restore strategies in the vein of high availability and disaster recovery. The first thing we'll look into is how to set up and configure a proper database backup and restore strategy that meets your organization's RPO and RTO objectives. Next, we'll show how to perform database backups using the available database tools. Then follow that up by showing how to perform a database, restore, also using the available database tools. From there, we'll discuss point in time restores and show how to perform a point in time database restore. Next, we'll talk about long-term backup retention and show how to configure long-term database retention. We'll follow that up by showing how to back up and restore a database using T-SQL. And lastly,…

Contents