SQL Server 2016 - Maintenance & Automation : Backup and Recovery | packtpub.com

775 views · Published 7 July 2017 · 3:24 · Indexed 22 October 2026

Channel: Packt · 2017 · Science & Technology

Watch on YouTube

This playlist/video has been uploaded for Marketing purposes and contains only selective videos. 

For the entire video course and code, visit [http://bit.ly/2tPu6gI].

In this section, we’ll take an overall look at the strategy and decide which backups we might need. We’ll then look at full backups and learn what they are, what they consist of, and how to create a full backup. We’ll then cover different backups, which are there to help us speed up our recovery and discuss and understand what these mean. We’ll then move on to log backups, which really allow us to avoid data loss by performing backups at particular points in time. That will cover our entire backup section, and then we’ll move on to the recovery part of the section. First, we’ll look at restore and find the overview and basics of it. We’ll then move to the more advanced settings, where we need to restore and recover logs, and finally we’ll talk about point in time restores, which will allow us to get the system back to a particular point in time before the disaster has occurred. 
• The Course Overview 
• Backup Strategy 
• Full Database Backups 
• Differential Database Backups 
• Transaction Log Backups 
• Basic Database Restores 
• Restoring Transaction Logs 
• Restoring to a Point in Time 


For the latest Big Data and Business Intelligence video tutorials, please visit
http://bit.ly/1HCjJik

Find us on Facebook -- http://www.facebook.com/Packtvideo
Follow us on Twitter - http://www.twitter.com/packtvideo

More from this channel