Overview

Introduction

The Backing up Databases module provides you with the instructions and devices to develop your hands-on skills in the following topics.

  • Working with jobs
  • Managing schedules
  • Working with transaction logs

Lab time: It will take approximately 60 minutes to complete this lab.

Exam Objectives

Five exam objectives are covered in this lab.

  • Creating a Job
  • Creating a schedule
  • Attaching a schedule to a job
  • Configure Automatic Backups with Task Scheduler
  • Back up a transaction log using SSMS

Exercise 1 - Working with Jobs

SQL Server Agent executes a series of administrative tasks known as jobs. You can create new jobs in SQL Server Agent. You can execute jobs multiple times and monitor the success or failure of the tasks. For example, you can create a job that will perform the back up of a database. The action to back up the database can be considered as a job step. In other words, every job includes job step(s).

In this exercise, you will create a new job to back up the database.

Exercise 2 - Managing Schedules

After the jobs are created, you need to create schedules that determine the time of job execution. You can attach a single schedule to multiple jobs or multiple schedules to a single job.

In this exercise, you will create a new schedule and attach it to the existing job.

Exercise 3 - Working with Transaction Logs

There are different types of database backups in SQL Server such as differential, full, transaction log, and so on.

In transaction log backup, the active transaction log files are backed up. The transactions that were performed after the full or differential backups are backed up in transaction log backup. You cannot use the transaction log backup type with ‘Simple’ recovery model. You must set the recovery model to ‘Full’ to perform a transaction log backup.

In this exercise, you will work with the transaction log backup type to back up the AdventureworksDW2016CTP3 database.

Comprehensive Learning

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