File & Piecemeal Restores

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

COURSE Backup Management
Likes 75 Likes 75  
CHANNEL Database Backup & Recovery
Likes 60 Likes 60  
CHANNEL Oracle Database 12c Administrator Certified Professional
Likes 30 Likes 30  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Backup Management
Likes 75 Likes 75  
COURSE Log Shipping & High Availability
Likes 34 Likes 34  
COURSE Data Access & Permissions
Likes 110 Likes 110