Microsoft SQL Server 2016: Restoring Databases
Interactive

Microsoft SQL Server 2016: Restoring Databases

Skillsoft
Updated Oct 17, 2019

Course Overview

An effective data protection strategy requires the ability to restore data from a backup in case of disaster, failure, or errors. This course covers restoring SQL Server 2016 databases, including how to perform piecemeal and page restores. It also covers performing point-in-time recovery, restoring file groups, and planning automation for restore testing. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.


Target Audience

Database administrators and database professionals


Learning Objectives

  • recognize what is involved in restoring a database, what can be restored, and restore scenario models
  • describe the purpose and prerequisites of restoring a database backup under the simple recovery model
  • restore a database under the simple recovery model
  • describe the purpose of and considerations for restoring a database under the full recovery model
  • restore a database under the full recovery model
  • restore a database under the full recovery model
  • automate and test restores
  • describe point-in-time recovery and perform point-in-time recovery using SQL Server Management Studio
  • perform point-in-time recovery using Transact-SQL
  • describe the goal of file restore and how it differs in the simple recovery model versus the full recovery model
  • restore files and filegroups
  • restore files to a new location
  • restore files and filegroups over existing files
  • recognize when a page restore is useful, as well as its limitations and restrictions
  • restore pages using SQL Server Management Studio and Transact-SQL
  • describe the purpose and process of piecemeal restore
  • describe the purpose and requirements of piecemeal restore in the simple recovery model
  • describe the purpose and requirements of piecemeal restore in the full recovery model
  • restore a database using a piecemeal restore
  • restore a database in SQL Server 2016