Transaction Logging Database Recovery

This topic describes procedures carried out from the tlmenu Database Recovery menu to recover a Transaction Logging database after a system or application has crashed. They include procedures for:

Note

  • The procedures for restoring from tape and reapplying updates from Clean Logs are not applicable where a database is enabled for Rapid Recovery. Refer to Rapid Database Recovery for a description of how to recover databases using Rapid Recovery.
  • If distributed transactions are being used, the Microsoft Distributed Transaction Co-ordinator's automatic recovery process must complete before you can restore the database and reapply Clean Logs. This is described in the topic Process Recovery.

Overview

Recovery of a Transaction Logging database after a system or application has crashed is carried out from the tlmenu Database Recovery menu displayed by selecting option 3 on the main Administration Options menu. Refer to tlmenu for an overview.

The procedures executed from this menu are detailed in this topic. Each procedure, started by selecting a sub-menu option comprises a sequence of message prompts to guide you through the process. Refer to the topic Replies to Prompts for a description of the required responses.

Recovery is carried out in two stages. First you remake the database, and restore the last save onto it using option 1 on the Database Recovery menu, then you replay all changes logged since that save using menu option 2.

Transaction Logging Menu System             Mon Jul 31 1999
Database name : /real0/dbase2               Host name : crime
State         : Transaction Handling/Logging enabled

     Database Recovery
     =================

     1. Restore the Database from the Most Recent Backup Tape
     2. Restore Clean Log(s) onto the Database

        Enter option (1-2) : _