Use the transaction log mirror to recovery from media failure.
There are no prerequisites for this task.
Contexte et remarques
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.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|