Database Restoration

SQL 2016    |    Intermediate
  • 9 videos | 1h 1m 3s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 60 users Rating 4.7 of 60 users (60)
An effective data protection strategy requires the ability to restore data from a backup in case of disaster, failure, or errors. Explore restoring SQL Server 2016 databases, including point-in-time recovery and automation for testing.

WHAT YOU WILL LEARN

  • Recognize what is involved in restoring a database, what can be restored, and restore scenario models
    Describe the purpose and prerequisites of restoring a database backup under the simple recovery model
    Restore a database under the simple recovery model
    Describe the purpose of and considerations for restoring a database under the full recovery model
    Restore a database under the full recovery model
  • Restore a database under the full recovery model
    Automate and test restores
    Describe point-in-time recovery and perform point-in-time recovery using sql server management studio
    Perform point-in-time recovery using transact-sql

IN THIS COURSE

  • 8m 33s
    Upon completion of this video, you will be able to recognize what is involved in restoring a database, what can be restored, and what restore scenario models are. FREE ACCESS
  • 4m 23s
    After completing this video, you will be able to describe the purpose and prerequisites of restoring a database backup under the simple recovery model. FREE ACCESS
  • Locked
    3.  Restoring a Database with the Simple Model
    5m 42s
    In this video, you will restore a database under the simple recovery model. FREE ACCESS
  • Locked
    4.  Complete Database Restores with the Full Model
    4m 25s
    After completing this video, you will be able to describe the purpose of and considerations for restoring a database under the full recovery model. FREE ACCESS
  • Locked
    5.  Restoring a Database with the Full Model Part 1
    4m 58s
    Learn how to restore a database under the full recovery model. FREE ACCESS
  • Locked
    6.  Restoring a Database with the Full Model Part 2
    8m 1s
    In this video, learn how to restore a database under the full recovery model. FREE ACCESS
  • Locked
    7.  Automating and Testing Restores
    8m 23s
    In this video, you will learn how to automate and test restores. FREE ACCESS
  • Locked
    8.  Performing Point-in-time Recovery with SSMS
    9m 50s
    After completing this video, you will be able to describe point-in-time recovery and perform point-in-time recovery using SQL Server Management Studio. FREE ACCESS
  • Locked
    9.  Performing Point-in-time Recovery with T-SQL
    6m 49s
    Learn how to perform point-in-time recovery using SQL. 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

Course CompTIA A+ Core 2: Backup & Recovery Methods
Rating 4.4 of 53 users Rating 4.4 of 53 users (53)
Course CompTIA Cloud+: Cloud Disaster Recovery
Rating 4.7 of 24 users Rating 4.7 of 24 users (24)
Book MySQL Crash Course: A Hands-on Introduction to Database Development

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)
Course Data Security & Azure SQL Database Options
Rating 4.6 of 67 users Rating 4.6 of 67 users (67)
Course Managing Database Integrity
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)