Subsequent primary database initialization

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

To create and initialize a Mirror Replication Agent instance

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

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

%SYBASE%\MA-15_1\bin\ma_admin -r myma.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 Mirror Activator Administration Guide, Chapter 2, “Setup and Configuration,” in the section titled, “Creating a Mirror Replication Agent instance using resource files.”
If your resource file set start_instance to no, start the Mirror Replication Agent instance.
1. Change to the directory containing your Mirror Replication Agent instance RUN file.
2. To start the Mirror Replication Agent instance, execute the RUN file, for example:
```
RUN_myma
```
Using the dsedit utility, update the Replication Server sql.ini file with the Mirror Replication Agent location, and verify the connection to the Mirror Replication Agent.
1. Open a command window in the SYBASE directory of your Mirror Replication Agent installation.
2. Set the environment variables by executing the SYBASE.bat file.
3. Use the Sybase isql utility to log in to Mirror Replication Agent:
```
isql -Usa -P -Smyma
```
  Here, myma is the name of Mirror Replication Agent.
If your resource file set initialize_instance to no, open a new command window, log in to the Mirror Replication Agent instance, and initialize the Mirror Replication Agent instance and the primary Microsoft SQL Server database using the following Mirror Replication Agent command:
```
pdb_init
```
If your resource file completed successfully and the instance was initialized and started, proceed to “Verifying the Mirror Replication Agent REPLICATING state”.