Here is another popular lab from Hands-On-Lab library: SQL Server Backup and Restore.
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
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.