BuyFind

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
BuyFind

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
Chapter 9, Problem 15RQ
Textbook Problem
2868 views

What three levels of backup may be used in database recovery management? Briefly describe what each backup level does.

Expert Solution
Program Plan Intro

Database recovery management:

  • It is a process of restoring the contents of the database from an inconsistent state to a state that was consistent previously.
  • It is process of bringing the database to a consistent state after a failure.

Explanation of Solution

Three levels of backup:

  • Backup ensures that data is available, when the contents of the database are lost accidently.
  • Backup is a part of preventive maintenance.
  • There are three levels of backup they are:
    • Full backup
    • Differential backup
    • Transition log backup

Full backup:

  • All the objects of the database are copied entirely.
  • A full backup of the content is made...

Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions
What are the components of PKI?

Principles of Information Security (MindTap Course List)

What does AISI stand for?

Precision Machining Technology (MindTap Course List)

Draw the top, the front and the right side orthogonal views of the given object and indicate when an object nee...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

The resultant of the three forces is a force R that passes through point B. Determine R and F.

International Edition---engineering Mechanics: Statics, 4th Edition

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

What is a head crash? (375)

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)