Contents Index Protecting against media failure on the transaction log Transaction log management

SQL Remote User's Guide
  Administering SQL Remote for Adaptive Server Enterprise
    Adaptive Server Enterprise transaction log and backup management

Stable queue recovery issues


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:

You can modify these stored procedures to issue dump database and dump transaction commands in the stable store database.


Contents Index Protecting against media failure on the transaction log Transaction log management