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
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
-
4:13
Fast Track to Adobe Captivate 6 Tutorial: Inserting New Slides | packtpub.com
-
3:24
UDK Game Programming with UnrealScript Tutorial: Configuring Kismet | packtpub.com
-
7:48
Building a Website with Drupal Tutorial: Content Types and Location | packtpub.com
-
2:40
Getting Started with Magento Tutorial: Introduction to Payment Methods | packtpub.com
-
3:25
Getting Started with Apache Maven Tutorial: Introducing Maven Plugins | packtpub.com
-
2:55
Moodle for Mobile Learning Tutorial: LTI (Learning Tool Interoperability) | packtpub.com
-
3:56
Moodle for Mobile Learning Tutorial: Embedding Twitter Feeds in Moodle | packtpub.com
-
4:27
XNA 3D Game Development By Example Tutorial: Drawing Sprites | packtpub.com