Join Martin Guidry for an in-depth discussion in this video Media sets and backup sets, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] In this section, we're going to…talk about media sets and backup sets.…A media set is a collection of backup media,…either tapes or disk files.…Each media set can contain one or more of these,…but it can only contain one type…so we cannot mix and match tapes…and disk files in the same media set,…and a media set is where one or…more backup sets will be written.…A backup set is the backup content…added to a media set during a single backup event.…
The machine will attempt to write…approximately an equal amount of information…across each member of the media set,…so if we take a backup and write it to a media set…with three items, either three tapes or three disk files,…than approximately one-third of the data…will be written to each member of the media set.…Backup sets much be restored as a whole.…We cannot restore part of a backup set,…so if you take a full backup onto a media set…that has three tapes, than you are going to need…all three of those tapes in order to do a restore.…
Creating large, complex media sets…
- Types of backups
- Media sets and backups
- Performing a basic backup using the GUI or command line
- Performing a basic restore using the GUI or command line
- Backing up and restoring logs
- Doing partial backup and restores
- Automating backups
- Using encryption and compression
Skill Level Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
SQL Server 2014: Installation and Administrationwith Ron Davis3h 40m Intermediate
Migrating Access Databases to SQL Serverwith Adam Wilbert2h 38m Intermediate
1. Backups in General
4. Partial Backups and Restores
5. Other Backup Topics
- 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.