SQL Server 2008 R2: Backups, Restores, and Database Snapshots

This course is included in our On-demand training solution.

Overview

Enterprises use databases to store their most critical data. To protect and ensure the data’s availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure the recovery of data, including a full recovery or a point-in-time recovery. SQL Server 2008 R2 also offers database snapshots, which can be used to revert a database to a specific point when the snapshot was taken. This helps to store historical data and provides protection against administrative errors. This course demonstrates how to perform backup and recovery operations, as well as how to create database snapshots and revert to a database snapshot. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.

Target Audience

Professionals typically pursuing a career as a Database Administrator; individuals who don’t work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.

Prerequisites

One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server

Expected Duration

90 min.

Course Objectives

Recovery Models and Backup Types

  • match the recovery models to their characteristics
  • identify the considerations for a backup and restore strategy
  • Performing Database Backups

  • recognize how to perform a database backup
  • Restoring SQL Server 2008 R2 Backups

  • recognize how the restore process works
  • recognize how to restore a SQL Server backup
  • Working with Database Snapshots

  • recognize the characteristics of a database snapshot
  • recognize how to configure a database snapshot
  • Backing Up and Restoring a Database

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?