Data Replication with SQL Remote
PART 4. Reference
CHAPTER 18. Command Reference for Adaptive Server Enterprise
To facilitate recovery from media failure, when the stable queue is in a separate database from the SQL Remote objects.
sp_queue_dump_transaction
sp_queue_dump_database procedure
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, it is important to recover the stable queue to a consistent point. The sp_queue_dump_transaction procedure is provided to help with recovery from media failure. It is called whenever a dump transaction is scanned.
As provided, the procedure does not carry out any operations. You can modify this stored procedure to issue a dump transaction command in the stable store database.