Contents Index sp_queue_dump_database procedure sp_queue_get_state procedure

SQL Remote User's Guide
  Command Reference for Adaptive Server Enterprise

sp_queue_dump_transaction procedure


Purpose 

To facilitate recovery from media failure, when the stable queue is in a separate database from the SQL Remote objects.

Syntax 

sp_queue_dump_transaction

See also 

sp_queue_dump_database procedure

Stable queue recovery issues

Description 

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.


Contents Index sp_queue_dump_database procedure sp_queue_get_state procedure