Contents Index Suspend and restart the connection Utilities and Options Reference

SQL Remote User's Guide
  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.


Contents Index Suspend and restart the connection Utilities and Options Reference