From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Overview of backup and restore in SQL Server

Overview of backup and restore in SQL Server - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

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. However, when we go to do a restore having to restore both a full…

Contents