Database Restoration

SQL 2016
  • 9 Videos | 1h 5m 33s
  • Includes Assessment
  • Earns a Badge
Likes 31 Likes 31
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

  • Playable
    1. 
    Database Restore
    8m 33s
    UP NEXT
  • Playable
    2. 
    Complete Database Restores with the Simple Model
    4m 23s
  • Locked
    3. 
    Restoring a Database with the Simple Model
    5m 42s
  • Locked
    4. 
    Complete Database Restores with the Full Model
    4m 25s
  • Locked
    5. 
    Restoring a Database with the Full Model Part 1
    4m 58s
  • Locked
    6. 
    Restoring a Database with the Full Model Part 2
    8m 1s
  • Locked
    7. 
    Automating and Testing Restores
    8m 23s
  • Locked
    8. 
    Performing Point-in-time Recovery with SSMS
    9m 50s
  • Locked
    9. 
    Performing Point-in-time Recovery with T-SQL
    6m 49s

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 60 Likes 60  
Likes 27 Likes 27  
Likes 14 Likes 14  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 25 Likes 25  
COURSE T-SQL Queries
Likes 112 Likes 112  
COURSE Encryption
Likes 69 Likes 69