From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 25,300 courses taught by industry experts.
Overview of backup and restore in SQL Server - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Overview of backup and restore in SQL Server
- [Instructor] In this section, we're going to talk about backup and restore in SQL Server 2016. SQL Server 2016 supports three different types of backups and those are full backups, differential backups, and log backups. So now let's talk about each one of those individually. A full backup, as its name implies, backs up everything, the entire database, all of the files, all of the data files, and all of the log files. A full backup must me done at least once before any of the other types of backups can be run. The differential backup backs up everything that has changed since the last full backup. So if you have very few things that have changed recently, a differential backup might be pretty small but if you have a high percentage of your data that has changed then the differential backup could be very large. Because differential backups are not backing up everything the backup usually runs quicker than a full backup.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.