Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm not a native English speaker and I've read the descriptions in BOL but still can't understand what exactly are they. Can anyone explain in an easy understand way?


share|improve this question

migrated from Jan 22 '13 at 6:30

This question came from our site for professional and enthusiast programmers.

The screenshots from SSMS will help you understand the terms:

backup set - is a backup from a single, successful backup operation. E.g. a full database backup created at 8 AM yesterday enter image description here

You can see that there are 2 backup sets in a single backup media set

backup device - a disk file or tape drive

backup media - tapes or disks where backup are stored backup media set - in the screenshot - it's the BAK file where backups are added

enter image description here

backup media family - You're creating the 8 AM full database backup and your database is huge, the backup takes more space than 4 tapes can store. Say you have 4 tape devices that are used to backup your database. When one tape is full, you insert a new one. If your database backup takes 20 tapes, that's 5 tapes per each tape device. The 5 tapes created on the tape device 1 belong to the same backup media family, as they have the same "father" - tape device 1

enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.