Create Differential Backups And Using Backup Compression In Sql Server 2008


show more Creating differential backups and using backup compression provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

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 h...

Creating differential backups and using backup compression
Video duration: 3m 40s 6h 54m Beginner

Viewers:

Creating differential backups and using backup compression provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...