Microsoft SQL Server 2016: Restoring Databases


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
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

Prerequisites
None

Expected Duration (hours)
2.1

Lesson Objectives

Microsoft SQL Server 2016: Restoring Databases

  • start the course
  • 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

    • Course Number:
    df_sqla_a05_it_enus

    Expertise Level
    Intermediate