From the course: SQL Server 2014 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 backups in SQL Server - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
Overview of backups in SQL Server
- Let's talk about some other different options of taking Backups in SQL Server 2014. SQL Server supports three different types of Backups. They are Full, Differential and Log. Let's talk about each one of these individually. A Full Backup, as it's name implies, will back up everything. It will back up all of the data, every file, every file group, every table, everything. A full backup must be done first before we can do the other types of backups. On a small database it might be all you ever need to do is the occasional full backup. Differential Backups, these will back up data that has changed since the last full backup. So if I take a full backup on Monday, then on Tuesday I could take a differential back up and the only thing backed up would be any data that has changed between Monday and Tuesday. This usually leads to a quicker backup. Obviously if we are backing up less data, it's going to be quicker, but this can lead to a slower restore process, because first we would have to…
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.