Contents Index Recovery from database media failure for consolidated databases Recovery with multiple transaction logs

SQL Remote User's Guide
  Administering SQL Remote for Adaptive Server Anywhere
    Transaction log and backup management
      Recovery from database media failure for consolidated databases

Recovery with a single transaction log

In this case, we assume that there is a single transaction log file, which has existed since the database was created. Also, we assume previous backups of the database file have been made and are available, for example on tape.

To recover the database

  1. Make a copy of the database and log file.

  2. Restore the database (.db) file, not the log file, from tape into a temporary directory.

  3. Start the database using the existing transaction log and the -a option, to apply the transactions and bring the database file up to date.

  4. Start the database in your normal way. Any new activity will be appended to the current transaction log.

Example 

This example illustrates recovery using a mirrored transaction log.

Suppose you have a consolidated database file named consol.db in a directory c:\dbdir, and a transaction log file c:\logdir\consol.log which is mirrored to d:\mirdir\consol.mlg.

To recover from media failure on the C drive

  1. Backup the mirrored transaction log d:\mirdir\consol.mlg.

  2. Replace the failed hardware and re-install all affected software.

  3. Create a temporary directory to perform the recovery in (for example, c:\recover)

  4. Restore the most recent backup of the database file, consol.db, to c:\recover\consol.db.

  5. Copy the mirror transaction log, d:\mirdir\consol.mlg, to the recovery directory with a .log extension, giving c:\recover\consol.log.

  6. Start the database using the following command line:

    dbeng9 -a C:\RECOVER\CONSOL.DB
  7. Shutdown the database server.

  8. Backup the recovered database and transaction log from c:\recover.

  9. Copy the files from c:\recover to the appropriate production directories:

  10. Restart your system normally.


Contents Index Recovery from database media failure for consolidated databases Recovery with multiple transaction logs