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.
Learning Objectives
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
- 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