Join Simon Allardice for an in-depth discussion in this video Creating differential backups and using backup compression, part of SQL Server 2008 Essential Training.
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 your full and your…
- Using T-SQL (Transact-SQL)
- Managing databases with SQL Server Management Studio
- Understanding database normalization
- Using SELECT statements
- Building indexes
- Monitoring database size and integrity
- Backing up and restoring databases
- Creating functions and stored procedures
- Managing database permissions
- Creating and formatting reports
- Adding charts to reports
- Creating and executing a simple SSIS package
Skill Level Beginner
1. Getting Started
2. Installing SQL Server 2008 R2
3. Tools and System Databases
SQL Server system databases2m 22s
4. Creating Databases
5. Importing Existing Data
6. Retrieving Data with SQL
7. Inserting and Updating Data
8. SQL Functions
9. Stored Procedures and Transactions
10. Core Administration Tasks
11. Backing Up and Restoring
12. Security Features
13. Reporting Services
14. Integration Services
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.