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