SQL Remote User's Guide
Using SQL Remote with Replication Server
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.