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. Wikipedia: 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

See Also

• Microsoft: Backing Up and Restoring Databases in SQL Server

References

Type classification: this is a lesson resource.

← Security

Database Fundamentals