Microsoft SQL Server 2016: Restoring Databases

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