< Database Fundamentals

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

Multimedia

  1. Microsoft Virtual Academy: SQL Server Administration Fundamentals

Activities

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

References

This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.