Microsoft · DP-300
Backup and restore
DP-300 · Lesson 20 of 22 · 2:52:49
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: a backup strategy with full, differential, and log backups, automated backups and point-in-time restore in Azure SQL, backup storage redundancy, native backups and restores on SQL Server (to disk or to URL), restore sequences with NORECOVERY and STOPAT, and long-term retention. Includes three original practice questions.
Preview the topics
- Contoso’s SQL Server VM must restore to any minute of the last week, with a full backup every Sunday. What else must it have?
- A table in Contoso’s Azure SQL database was emptied by mistake at 10:42 today. How should the DBA recover the rows?
- Contoso must keep the first backup of each year for seven years, and make sure that nobody can delete those backups early, in Azure SQL Database. What should it configure?