Microsoft SQL Server 2012: Backing Up and Restoring Databases


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
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 data can be recovered, including to the point of failure or a point-in-time recovery. This course demonstrates how to perform backup and recovery operations.This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who do not 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 among others; Database Administrators who as part of their daily task perform installation, maintenance, and configuration tasks

Expected Duration (hours)
1.5

Lesson Objectives

Microsoft SQL Server 2012: Backing Up and Restoring Databases

  • determine the most appropriate recovery model for a given scenario
  • choose a logical backup device
  • match the different kinds of backups to their descriptions
  • recognize how to create a database backup
  • describe the consideration involved in planning to restore a database
  • recognize how to restore a database for a given scenario
  • determine when to use particular backup types
  • determine which recovery models and backup types should be used in a given scenario
  • create database backups
  • use SQL Server 2012 restore features
  • Course Number:
    md_msdb_a07_it_enus

    Expertise Level
    Beginner