User's Manual

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” on page 415
“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_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.
416