Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.