Subsequent initialization

Use the following procedure only if you have already initialized the primary data server, as described in “First-time initialization”, and you want to create another Replication Agent instance. This procedure creates and initializes only the Replication Agent instance, not the primary data server.

StepsTo create and initialize a Replication Agent instance

  1. Execute the resource file to create the Replication Agent instance.

    1. After the resource file has been validated as described in “Configuring and validating the Replication Agent resource file”, use the ra_admin utility to create the Replication Agent instance using the -r parameter, for example:

      %SYBASE%\RAX-15_1\bin\ra_admin -r myra.rs
      

      Execution results are returned as one of the following:

      • Response-file processing completed

      • Response-file processing completed with errors

      For more information about the resource file or its use, refer to the Replication Agent Administration Guide, Chapter 2, “Setup and Configuration,” in the section titled, “Creating a Replication Agent instance using resource files.”

  2. If your resource file set initialize_instance to no, start the Replication Agent instance.

    1. Change to the directory containing your Replication Agent instance RUN file, for example:

    2. To start the Replication Agent instance, execute the RUN file, for example:

      RUN_myra
      
  3. Using the dsedit utility, update the Replication Server sql.ini file with the Replication Agent location, and verify the connection to the Replication Agent.

    1. Open a command window in the SYBASE directory of your Replication Agent installation.

    2. Set the environment variables by executing the SYBASE.bat file.

    3. Use the Sybase isql utility to log in to Replication Agent:

      isql -Usa -P -Smyra
      

      Here, myra is the name of Replication Agent.

  4. If your resource file set initialize_instance to no, open a new command window, log in to the Replication Agent instance, and initialize the Replication Agent instance and the primary Microsoft SQL Server database using the following Replication Agent command:

    pdb_xlog init
    

Your Replication Agent instance is now running and has been initialized. Continue with “Verifying the Replication Agent Replicating state”.