SQL Remote User's Guide
Administering SQL Remote for Adaptive Server Enterprise
Adaptive Server Enterprise transaction log and backup management
Keeping the stable queue in a separate database complicates backup and recovery, as consistent versions of the two databases have to be recovered.
Normal recovery automatically restores the two databases to a consistent state, but recovery from media failure takes some care. When restoring database dumps and transaction dumps, it is important to recover the stable queue to a consistent point.
Two procedures in the stable store database are provided to help with recovery from media failure:
sp_queue_dump_database This procedure is called whenever a dump database is scanned from the transaction log.
sp_queue_dump_transaction This procedure is called whenever a dump transaction is scanned from the transaction log.
You can modify these stored procedures to issue dump database and dump transaction commands in the stable store database.