Configure and Maintain a Backup Strategy

Practice Labs Module
Time
40 minutes
Difficulty
Intermediate

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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

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
Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.