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:^[1]

• 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. Read Wikipedia: Backup.

Multimedia

1. Watch 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.^[2]
• 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.^[3]
• Each differential backup saves the data that has changed since the last full backup.^[4]

Key Terms

backup

base

data backup

differential backup

full backup

incremental backup

log backup

restore

See Also

• Microsoft: Backing Up and Restoring Databases in SQL Server

References

Resource type: this resource is a lesson.