CSE Roadmap

Core tier · about 2 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Explain the difference between a full backup and an incremental backup.
  • Explain how point-in-time recovery combines a backup with the log to reach any specific moment.
  • Explain why a backup must be stored on separate media from the live database.
  • Decide, for a given scenario, whether crash recovery or a backup restore is the right tool.

This level opened by naming disk failure as a category crash recovery cannot handle, since it may destroy the very log that recovery depends on. This page covers the mechanism that specifically handles that case, and the equally common case of simple human error: the backup.