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
-
1.Database Restore8m 33sUP NEXT
-
2.Complete Database Restores with the Simple Model4m 23s
-
3.Restoring a Database with the Simple Model5m 42s
-
4.Complete Database Restores with the Full Model4m 25s
-
5.Restoring a Database with the Full Model Part 14m 58s
-
6.Restoring a Database with the Full Model Part 28m 1s
-
7.Automating and Testing Restores8m 23s
-
8.Performing Point-in-time Recovery with SSMS9m 50s
-
9.Performing Point-in-time Recovery with T-SQL6m 49s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.