In this hands-on lab scenario, your organization, Awesome Company, is reducing its on-site footprint and moving as many databases as possible to the cloud. As part of this effort, you have already migrated multiple databases to both Azure SQL Database and Azure SQL Virtual Machines. Unfortunately, during the course of use, some data has been accidentally deleted from these databases. It is up to you as the DBA to recover this lost information and guard against future issues. Performing the actions of this lab will help you become familiar with SQL backup and recovery options in Azure.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Restore a Database to a SQL Virtual Machine
Using the GitHub link, restore a full backup of the
acmobiledatabase to your SQL virtual machine.- Configure Automatic Backups on the SQL Virtual Machine
To ensure there are backups in place for future incidents, configure automated backups for your SQL virtual machine.
- Recover Lost Information in Azure SQL Database
Use a point-in-time restore to recover a dropped table in the
acwebdatabase.
