Rebuild Stable Queues

The rebuild queues command removes all existing queues and rebuilds them. It cannot rebuild individual stable queues.

You can rebuild queues online or off-line, depending on your situation. Generally, you rebuild queues online first to detect if there are lost stable queue messages. If there are lost messages, you can retrieve them by first putting the Replication Server in standalone mode and recovering the data from an off-line log.

See Replication Server Reference Manual > Replication Server Commands > rebuild queues.

• Rebuild Queues Online
  During the online rebuild process, the Replication Server is in normal mode. All RepAgents and other Replication Servers are automatically disconnected from the Replication Server.
• Rebuild Queues from Offline Database Logs
  You can recover data from off-line database logs.
• Loss Detection After Rebuilding Stable Queues
  Replication Server performs loss detection to determine if any messages could not be recovered after the stable queues were rebuilt.
• Set Log Recovery for Databases
  Manually setting log recovery is part of recovering from truncated primary database logs off-line, or restoring primary and replicate databases from dumps.
• Loss Detection After Setting Log Recovery
  While you are applying the temporary recovery database to the primary database, Replication Server may detect SQM loss between a primary database and the Replication Server that manages that primary database.
• Determine Which Dumps to Load
  When loading transaction log dumps, always examine the Checking Loss message that is displayed during loss detection.
• Adjust Database Generation Numbers
  Any time you load a database for recovery, you may be required to change the database generation number, as instructed in the recovery procedure you are using.