Font size:

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.

Learning Objectives
  • 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
Register Now
Microsoft SQL Server 2012: Backing Up and Restoring Databases Online course
  • Course ID:
  • Duration:
    90 minutes
  • Price: