File & Piecemeal Restores

SQL 2016    |    Intermediate
  • 11 videos | 57m 45s
  • Includes Assessment
  • Earns a Badge
Likes 61 Likes 61
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

  • 5m 20s
    Upon completion of this video, you will be able to describe the goal of file restore and how it differs in the simple recovery model versus the full recovery model. FREE ACCESS
  • 7m 1s
    Learn how to restore files and filegroups. FREE ACCESS
  • Locked
    3.  Restoring Files to a New Location
    5m 26s
    In this video, learn how to restore files to a new location. FREE ACCESS
  • Locked
    4.  Restoring File and Filegroups over Existing Files
    4m 20s
    In this video, you will learn how to restore files and filegroups over existing files. FREE ACCESS
  • Locked
    5.  Page Restores
    2m 56s
    After completing this video, you will be able to recognize when a page restore is useful, as well as its limitations and restrictions. FREE ACCESS
  • Locked
    6.  Restoring Pages Using SSMS
    7m 27s
    In this video, you will learn how to restore pages using SQL Server Management Studio and Transact-SQL. FREE ACCESS
  • Locked
    7.  Piecemeal Restores
    5m 6s
    Upon completion of this video, you will be able to describe the purpose and process of a piecemeal restore. FREE ACCESS
  • Locked
    8.  Piecemeal Restore with the Simple Recovery Model
    4m 38s
    Upon completion of this video, you will be able to describe the purpose and requirements of piecemeal restore for databases using the simple recovery model. FREE ACCESS
  • Locked
    9.  Piecemeal Restore with the Full Recovery Model
    3m 11s
    After completing this video, you will be able to describe the purpose and requirements of piecemeal restore in the full recovery model. FREE ACCESS
  • Locked
    10.  Performing a Piecemeal Restore
    7m 8s
    In this video, you will learn how to restore a database using a piecemeal restore. FREE ACCESS
  • Locked
    11.  Exercise: Restoring a Database in SQL Server 2016
    5m 13s
    To find out how to restore a database in SQL Server 2016, consult the documentation or a qualified IT professional. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Database Backup & Recovery
Likes 71 Likes 71  
Course Backup Management
Likes 110 Likes 110  
Course CompTIA A+ Core 2: Backup & Recovery Methods

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Managing Database Integrity
Likes 37 Likes 37  
Course Backup Management
Likes 110 Likes 110  
Course Database Mail & Alerts
Likes 57 Likes 57