Recovering from media failure on a transaction log mirror
 Recover from media failure on a transaction log mirror

This procedure explains how to recover from a media failure when you are using a transaction log mirror. If your database is a consolidated database in a SQL Remote installation, you should use a transaction log mirror, or a hardware equivalent.

  1. Make an extra copy of the backup of your database file taken at the time the transaction log was started.

  2. Identify which of the two files is corrupt. Run the Log Translation utility (dbtran) on the transaction log and on its mirror. The file that generates an error message is corrupt. The Log Translation utility is accessible from Sybase Central or as the dbtran utility.

    The following command line translates a transaction log named demo.log, placing the translated output into demo.sql:

    dbtran demo.log

    The Log Translation utility properly translates the intact file, and reports an error while translating the corrupt file.

  3. Copy the correct file over the corrupt file.

  4. Restart the database server.

 See also