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.
To create and initialize a Replication Agent instance
Execute the resource file to create the Replication Agent instance.
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.”
If your resource file set initialize_instance to no, start the Replication Agent instance.
Change to the directory containing your Replication Agent instance RUN file, for example:
To start the Replication Agent instance, execute the RUN file, for example:
RUN_myra
Using the dsedit utility, update the Replication Server sql.ini file with the Replication Agent location, and verify the connection to the Replication Agent.
Open a command window in the SYBASE directory of your Replication Agent installation.
Set the environment variables by executing the SYBASE.bat file.
Use the Sybase isql utility to log in to Replication Agent:
isql -Usa -P -Smyra
Here, myra is the name of Replication Agent.
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”.