Page 128 - DCAP508_DATABASE_ADMINISTRATION

Database Administration Deepak Mehta, Lovely Professional University

Notes Unit 9: Database Recovery Models

CONTENTS
Objectives

Introduction
9.1 Common Terms
9.2 Recovery Models
9.3 Partial Database Restore
9.4 How to View or Change the Recovery Model of a Database
9.4.1 To View or Change the Recovery Model of a Database
9.4.2 Considerations for Switching from the Simple Recovery Model
9.4.3 Considerations for Switching to the Full Recovery Model
9.4.4 Considerations for Switching to the Simple Recovery Model

9.4.5 Switching between Full and Bulk-Logged Recovery
9.4.6 Switching from Full or Bulk-Logged to Simple Recovery
9.5 Changing the Recovery Model
9.6 Summary
9.7 Keywords
9.8 Review Questions
9.9 Further Readings

Objectives

After studying this unit, you will be able to:
Know about the common terms in database backup
Discuss the various recovery models in SQL server
Learn how to View or Change the Recovery Model of a Database

Understand the process of switching from Full or Bulk-Logged to Simple Recovery
Introduction

The need to back up databases on a regular basis is a major component of managing any
production system. Backups may be used to provide a means of recovery from a disaster
situation. Microsoft® SQL Server™ 2000 provides several kinds of recovery models that may be
combined to formulate a customized disaster recovery plan depending on the nature of the data
and the disaster recovery requirements. SQL Server 2000 enhances some aspects of the backup
and restore functionality that was provided in SQL Server 7. There is also additional functionality
that helps individual organizations take full advantage of commands in SQL Server 2000.
9.1 Common Terms

1. Data page: An SQL Server database’s basic data storage structure is 8 KB and is known as
a data page. An SQL database may contain thousands of pages.

122 LOVELY PROFESSIONAL UNIVERSITY