If you have initialized Replication Agent for the first time, have subsequently de-initialized Replication Agent using pdb_xlog remove, and want to re-initialize this Replication Agent instance or another Replication Agent instance for a different database in the same primary data server, use the following procedure.
Subsequently initializing Replication Agent instances
Determine the primary Microsoft SQL Server DAC port number, and make sure Microsoft SQL Server is configured to allow a remote DAC. Use the Microsoft SQL Server Surface Area Configuration tool to enable a remote DAC:
From the Windows Start menu, choose Microsoft SQL Server | Surface Area Configuration | Configuration Tools | SQL Server Surface Area Configuration | Surface Area Configuration for Features.
In the Surface Area Configuration for Features window, choose DAC under MSSQLSERVER/Database Engine, and make sure the Enable remote DAC check box is selected.
Log in to your Replication Agent, and set the pds_dac_port_number configuration parameter.
Configure the following Replication Agent connectivity parameters for the Microsoft SQL Server primary database:
pds_server_name
pds_database_name
pds_username
pds_password
For information about these configuration parameters, see the Replication Agent Installation Guide and Replication Agent Reference Manual.
Verify that Replication Agent can connect to the primary database:
test_connection PDS
Initialize the Microsoft SQL Server data server and Replication Agent:
pdb_xlog init
