Use the transaction log mirror to recovery from media failure.
There are no prerequisites for this task.
Context and remarks
If your database is a consolidated database in a SQL Remote installation, you should use a transaction log mirror or a hardware equivalent.
Make an extra copy of the backup of your database file taken at the time the transaction log was started.
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 following command translates a transaction log named demo.log, placing the translated output into demo.sql:
Copy the correct file over the corrupt file.
Restart the database server.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|