Download View this document as PDF

Microsoft SQL Server Replication Setup
cd %SYBASE%\RAX-15_5\myra
b) Execute the RUN file, for example:
RUN_myra
10. Initialize Replication Agent.
a) Log in to Replication Agent using isql:
isql –Usa –P –Smyra
where myra is the name of Replication Agent.
b) Issue:
pdb_xlog init
The Replication Agent instance is now running, and the primary data server and the
Replication Agent instance have been initialized.
Subsequent initialization
Create another Replication Agent instance, after you have already initialized the primary data
server.
See also
• Verifying the Replication Agent Replicating State on page 64
Creating and Initializing a Replication Agent Instance
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_5\bin\ra_admin -r myra.rs
Execution results are returned as either:
•
•
Response-file processing completed
Or
Response-file processing completed with errors
See the Replication Agent Administration Guide.
2. If your resource file has initialize_instance set to no, start the Replication Agent instance.
a) Change to the directory containing your Replication Agent instance RUN file, for
example:
b) Execute the RUN file, for example:
RUN_myra
3. Use the dsedit utility to update the Replication Server sql.ini file with the Replication
Agent location, and verify the connection to the Replication Agent.
Quick Start Guide
63