Database Fundamentals/Backup and Restore

This lesson introduces database backup and restore.

Objectives and Skills
Objectives and skills for the database backup and restore portion of Microsoft Exam 98-364 Database Fundamentals include:
 * Administer a database
 * Understand database backups and restore
 * Understand various backup types, such as full and incremental, importance of backups, how to restore a database

Readings

 * 1)  Backup

Multimedia

 * 1) Microsoft Virtual Academy: SQL Server Administration Fundamentals

Lesson Summary

 * A backup, or the process of backing up, refers to the copying and archiving of computer data so it may be used to restore the original after a data loss event.
 * An incremental style repository aims to make it more feasible to store backups from more points in time by organizing the data into increments of change between points in time.
 * Each differential backup saves the data that has changed since the last full backup.

Key Terms

 * backup
 * base
 * data backup
 * differential backup
 * full backup
 * incremental backup
 * log backup
 * restore