Configure and Maintain a Backup Strategy
The "Configure and Maintain a Backup Strategy" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: Managing Backups, Restoring Databases.
Introduction
The Configure and Maintain a Backup Strategy module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:
- Managing Backups
- Restoring Databases
Exercise 1 - Managing Backups
In this exercise, you will perform the tasks required to configure and maintain a backup strategy.
In this exercise, you will learn the following about Microsoft SQL Server 2012:
- Different backup models, including point-in-time recovery
- Protecting customer data even if backup media is lost
- Performing backup/restore based on proper strategies including backup redundancy
- Implementing and testing a database implementation and backup strategy
- Backing up an SQL Server environment
- Backing up a system database
Exercise 2 - Restoring Databases
In this exercise, you will perform the tasks required to restore databases.
In this exercise, you will learn the following about Microsoft SQL Server 2012:
- Restoring a database secured with TDE
- Recovering data from a damaged database
- Restoring to point-in-time
- Performing a filegroup restore
- Performing a page-level restore
See the full benefits of our immersive learning experience with interactive courses and guided career paths.