Configuring Replication Servers to manage primary tables

If you want to add a route from a Replication Server that used to be configured as a replicate-only Replication Server, the RSSD for that Replication Server requires an LTM.

To add an LTM for the RSSD, perform the following steps:

  1. To set the LTM truncation point for the RSSD to “valid,” log in to the SQL Server as “sa” and execute the following commands:

    use RSSD_database
    go
    dbcc settrunc('ltm,' 'valid')
    go
    
  2. To allow the Replication Server to receive messages from the LTM, execute the following command at the Replication Server:

    alter connection to RSSD_data_server.RSSD_database
    set log transfer on
    
  3. Add an interfaces file entry for the LTM.

    Use ds_edit to modify the interfaces file. See the Replication Server Installation Guide for more information.

  4. Create an LTM configuration file.

  5. Run the LTM for the configuration file.