Learn Backup, Recovery, and Restore Through Practice

Practice how to administrate the database, create a backup, and perform restore operations.

Problem

The problem is divided into three parts, A, B, and C.

Part A

Let’s say we're in the middle of a large database project and need to back up the database.

Use SQL syntax (and the examples in the previous lessons) to set the recovery model CompanyDb to FULL to prepare for the backup process.

Get hands-on with 1200+ tech skills courses.