SQL Remote User's Guide
Administering SQL Remote for Adaptive Server Anywhere
Transaction log and backup management
This section describes how to recover from a media failure on the database device at the consolidated database.
The procedures to follow are easiest to describe if there is only one transaction log file. While this might not be common for consolidated databases, it is described first, followed by a more common but complicated situation with a set of transaction log files.
Recovery with a single transaction log
Recovery with multiple transaction logs