File & Piecemeal Restores

SQL 2016
  • 11 Videos | 1h 2m 45s
  • Includes Assessment
  • Earns a Badge
Likes 41 Likes 41
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

  • Playable
    1. 
    File Restores
    5m 20s
    UP NEXT
  • Playable
    2. 
    Restoring File and Filegroups
    7m 1s
  • Locked
    3. 
    Restoring Files to a New Location
    5m 26s
  • Locked
    4. 
    Restoring File and Filegroups over Existing Files
    4m 20s
  • Locked
    5. 
    Page Restores
    2m 56s
  • Locked
    6. 
    Restoring Pages Using SSMS
    7m 27s
  • Locked
    7. 
    Piecemeal Restores
    5m 6s
  • Locked
    8. 
    Piecemeal Restore with the Simple Recovery Model
    4m 38s
  • Locked
    9. 
    Piecemeal Restore with the Full Recovery Model
    3m 11s
  • Locked
    10. 
    Performing a Piecemeal Restore
    7m 8s
  • Locked
    11. 
    Exercise: Restoring a Database in SQL Server 2016
    5m 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.

YOU MIGHT ALSO LIKE

Likes 59 Likes 59  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Auditing
Likes 39 Likes 39  
Likes 75 Likes 75  
Likes 27 Likes 27