From the course: SQL Server 2008 Essential Training

Unlock the full course today

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

Creating differential backups and using backup compression

Creating differential backups and using backup compression - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Creating differential backups and using backup compression

Once we've done at least one full backup, we can actually continue to do the next ones by doing differential ones, although every now and then we'll do a full backup again. All we do with this is go in and just change our backup type to Differential, and I can just click OK. Now that's not very exciting, so let me show you a couple of other options that you have there. Once again just going back into the database, Tasks and Backup. To get a bit of information about how many times we have done a full backup, how many times you've done a differential backup, we can select the destination path and come down here to the Contents button. And that will allow us to kind of step through or different backup sets, which ones were full, which ones were differential, and how long we've been keeping them around for. This whole collection, this whole suite of full and differential backups, are in order and they are known as a media-set. SQL Server likes to understand the history of how you've done…

Contents