SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

IT Professional Curricula Enterprise Database Systems Solution Area Microsoft SQL Server 2016 Microsoft SQL Server 2016: Administering

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 learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Asset ID	df_sqla_a05_it_enus
Course Type	Video Course
Course Category	Enterprise Database Systems Solution Area

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 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

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
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