Database Restoration
SQL 2016
| Intermediate
- 9 videos | 1h 1m 3s
- Includes Assessment
- Earns a Badge
An effective data protection strategy requires the ability to restore data from a backup in case of disaster, failure, or errors. Explore restoring SQL Server 2016 databases, including point-in-time recovery and automation for testing.
WHAT YOU WILL LEARN
-
Recognize what is involved in restoring a database, what can be restored, and restore scenario modelsDescribe the purpose and prerequisites of restoring a database backup under the simple recovery modelRestore a database under the simple recovery modelDescribe the purpose of and considerations for restoring a database under the full recovery modelRestore a database under the full recovery model
-
Restore a database under the full recovery modelAutomate and test restoresDescribe point-in-time recovery and perform point-in-time recovery using sql server management studioPerform point-in-time recovery using transact-sql
IN THIS COURSE
-
8m 33sUpon completion of this video, you will be able to recognize what is involved in restoring a database, what can be restored, and what restore scenario models are. FREE ACCESS
-
4m 23sAfter completing this video, you will be able to describe the purpose and prerequisites of restoring a database backup under the simple recovery model. FREE ACCESS
-
5m 42sIn this video, you will restore a database under the simple recovery model. FREE ACCESS
-
4m 25sAfter completing this video, you will be able to describe the purpose of and considerations for restoring a database under the full recovery model. FREE ACCESS
-
4m 58sLearn how to restore a database under the full recovery model. FREE ACCESS
-
8m 1sIn this video, learn how to restore a database under the full recovery model. FREE ACCESS
-
8m 23sIn this video, you will learn how to automate and test restores. FREE ACCESS
-
9m 50sAfter completing this video, you will be able to describe point-in-time recovery and perform point-in-time recovery using SQL Server Management Studio. FREE ACCESS
-
6m 49sLearn how to perform point-in-time recovery using SQL. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course
File & Piecemeal Restores

Course
Auditing