Microsoft SQL Server 2012: Backing Up and Restoring Databases

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