Recovering from Media Failure on the Database Transaction Log

You can recover the ERSSD database transaction log.

1. Identify the corrupted file. You can do this by running the Log Translation utility on both the transaction log and its mirror to see which one generates an error message. In this example, the Log Translation utility, dbtran, translates a transaction log named erssd_name.log, saving the translated output in db_name.sql.

   dbtran erssd_name.log

   The Log Translation utility translates the intact file with no errors, but reports an error when translating the corrupt file.

2. Copy the correct file over the corrupted file, so that the two files are identical.
3. Restart the database, using command from the Replication Server error log.
4. Restart Replication Server.