File & Piecemeal Restores
SQL 2016
| Intermediate
- 11 Videos | 57m 45s
- Includes Assessment
- Earns a Badge
In the event of an unforeseen disaster, critical data should be protected and easily recoverable. Discover how to perform piecemeal and page restores, and restoring file groups.
WHAT YOU WILL LEARN
-
describe the goal of file restore and how it differs in the simple recovery model versus the full recovery modelrestore files and filegroupsrestore files to a new locationrestore files and filegroups over existing filesrecognize when a page restore is useful, as well as its limitations and restrictionsrestore pages using SQL Server Management Studio and Transact-SQL
-
describe the purpose and process of piecemeal restoredescribe the purpose and requirements of piecemeal restore in the simple recovery modeldescribe the purpose and requirements of piecemeal restore in the full recovery modelrestore a database using a piecemeal restorerestore a database in SQL Server 2016
IN THIS COURSE
-
1.File Restores5m 20sUP NEXT
-
2.Restoring File and Filegroups7m 1s
-
3.Restoring Files to a New Location5m 26s
-
4.Restoring File and Filegroups over Existing Files4m 20s
-
5.Page Restores2m 56s
-
6.Restoring Pages Using SSMS7m 27s
-
7.Piecemeal Restores5m 6s
-
8.Piecemeal Restore with the Simple Recovery Model4m 38s
-
9.Piecemeal Restore with the Full Recovery Model3m 11s
-
10.Performing a Piecemeal Restore7m 8s
-
11.Exercise: Restoring a Database in SQL Server 20165m 13s
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.