O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Restore and Recovery Concepts

In order to better understand how to restore data, it helps to know the terminology and concepts behind the restore process. This section defines terms that are used throughout the chapter and explains the phases of the restore process.

There are three possible phases in a restore operation: the data copy, redo, and undo phases. The term restore is used here in a more specific way to describe the first two phases of a restore operation: the data copy and redo (roll forward) phases. Recovery is the term used to describe the phase that performs undo (roll back) and brings the database online to a recovered state. The following are descriptions of these three phases, which are summarized in Table 15-1:

  • Data Copy Phase ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required