Page 137 - DCAP508_DATABASE_ADMINISTRATION

Deepak Mehta, Lovely Professional University
Unit 10: Database Backup and Restore

Unit 10: Database Backup and Restore Notes

CONTENTS
Objectives

Introduction
10.1 Backup Types and Options
10.1.1 Types of Backups
10.1.2 Backup Media

10.1.3 Permissions Required for Backup and Restore
10.2 Complete Database Backup
10.2.1 Performing Complete Database Backups
10.3 Restoring Database

10.3.1 Restoring a Complete Backup to the Same Database
10.4 Database Snapshots
10.4.1 Meaning of Database Snapshot
10.4.2 How Database Snapshots Work

10.4.3 Effect of the Update Pattern on Database Snapshot Growth
10.4.4 Metadata about Database Snapshots
10.4.5 Typical Uses of Database Snapshots
10.4.6 Reasons to take Database Snapshots

10.4.7 Limitations and Requirements of Database Snapshots
10.4.8 Creating a Database Snapshot
10.5 Summary
10.6 Keywords

10.7 Review Questions
10.8 Further Readings

Objectives

After studying this unit, you will be able to:

Learn about the basic data backup models
Know how backup functionality can be used in a disaster recovery plan
Describe various types of backup media
Understand the concept of database snapshot and its use
Learn how to create a database snapshot

LOVELY PROFESSIONAL UNIVERSITY 131