User's Manual

Chapter 13. Using SQL Remote with Replication Server
Other issues
This section lists other issues regarding using SQL Remote with Replication
Server.
Running the Message Agent The Message Agent should be run with
command-line options to receive and send (-r and -s). This will prevent the
Message Agent from attempting to scan the transaction log. If the Message
Agent attempts to scan the transaction log while the Replication Agent is
running, it will get an error attempting to reserve the “log transfer context”.
Procedure calls in SQL Remote Open Server The SQL Remote Open
Server passes all procedure calls it receives from Replication Server through
to the stable queue database. For example, rs_get_lastcommit and
rs_update_lastcommit are executed in the stable queue database.
Coordinated dumps Replication Server provides a mechanism to
coordinate database dumps and transaction log dumps between the main
database and the stable queue database. The rs_dumpdb and rs_dumptran
function strings can be used to perform coordinated dumps of the stable
queue database. Please see the Replication Server documentation for more
information.
Schema changes If you make any schema changes to a SQL Remote
installation, you must do so on a quiet system. This includes shutting down
the SQL Remote Open Server.
287