User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise
sp_queue_dump_database 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_database
See also “sp_queue_dump_transaction procedure” on page 416
“Stable queue recovery issues” on page 273
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_database procedure is provided to help with
recovery from media failure. It is called whenever a dump database is
scanned.
As provided, the procedure does not carry out any operations. You can
modify this stored procedure to issue a dump database command in the
stable store database.
415