User's Manual

Setting up SQL Remote Open Server
This section describes how to set up a SQL Remote installation using the
SQL Remote Open Server. The procedure depends on whether the
SQL Remote stable queue is being kept in a separate Adaptive Server
Enterprise database from the tables being replicated or in the same Adaptive
Server Enterprise database.
☞ For more information about stable queue location, see “The stable
queue” on page 265.
Initial copies of the data The setup procedure assumes you are using the extraction utility to produce
an initial copy of the data in each remote database. You must be sure not to
use the Replication Server materialization feature for this purpose.
The procedure for setting up SQL Remote Open Server has two stages:
♦ Prepare a SQL Remote setup This stage depends on whether you have
an existing SQL Remote installation or not.
♦ Add the SQL Remote Open Server to the setup This stage is the
same regardless of previous installations.
❖ To prepare your SQL Remote setup, if you have an existing SQL
Remote installation
1. On a quiet primary database, use the Message Agent to scan any
remaining transactions into the stable queue.
A quiet database is one where neither the Message Agent nor the
SQL Remote Open Server is running, and where no transactions are
being replicated.
2. Follow the steps in the section “Upgrading SQL Remote for Adaptive
Server Enterprise” on page 25 to upgrade your SQL Remote software at
the consolidated site.
3. Invalidate the Message Agent truncation point at the consolidated
database using the following command:
dbcc settrunc( ’ltm’, ’ignore’ )
4. At the stable queue database, execute the stored procedure
sp_queue_log_transfer_reset.
282