Database Fundamentals/Backup and Restore

From Wikiversity
Jump to navigation Jump to search

This lesson introduces database backup and restore.

Objectives and Skills[edit]

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[edit]

  1. Wikipedia: Backup

Multimedia[edit]

  1. Microsoft Virtual Academy: SQL Server Administration Fundamentals

Activities[edit]

Lesson Summary[edit]

  • 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[edit]

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

See Also[edit]

References[edit]

Nuvola apps edu miscellaneous.svg Type classification: this is a lesson resource.