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 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
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
-
3. Restoring a Database with the Simple Model5m 42sIn this video, you will restore a database under the simple recovery model. FREE ACCESS
-
4. Complete Database Restores with the Full Model4m 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
-
5. Restoring a Database with the Full Model Part 14m 58sLearn how to restore a database under the full recovery model. FREE ACCESS
-
6. Restoring a Database with the Full Model Part 28m 1sIn this video, learn how to restore a database under the full recovery model. FREE ACCESS
-
7. Automating and Testing Restores8m 23sIn this video, you will learn how to automate and test restores. FREE ACCESS
-
8. Performing Point-in-time Recovery with SSMS9m 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
-
9. Performing Point-in-time Recovery with T-SQL6m 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.
