Backups are important to restore a database at the time of adversity or any scheduled maintenance. In this lab, you will learn how to take different types of backup, take backup using other backup options like compression, password etc. using T-SQL and restoring a database from the available backups using T-SQL. This lab will have a detailed study on designing database backup strategies.
Exercise 1: Backups
Exercise 2: Backup options
Exercise 3: Restoring Databases
Exercise 4: Designing Database backup strategy