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.
  • 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:
    234994
  • Duration:
    90 minutes
  • Price:
    $75