Microsoft SQL Server 2016: Restoring Databases

Database administrators and database professionals

Prerequisite
None

Expected Duration
127 minutes

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.

Objective

Restoring a Database

  • 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

Performing Point-in-time Recovery

  • describe point-in-time recovery and perform point-in-time recovery using SQL Server Management Studio
  • perform point-in-time recovery using Transact-SQL

Performing File and Page Restores

  • 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

Using Piecemeal Restores

  • 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

Practice: Restoring a Database

  • restore a database in SQL Server 2016

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.