Initializes the primary database in preparation for Mirror Replication Agent initialization.
pdb_init [move_truncpt]
The optional keyword that sets the secondary truncation point to the end of the primary database transaction log.
pdb_init
This command initializes the primary database, and if the secondary truncation point is not already set, it sets the secondary truncation point to the end of the transaction log.
pdb_init move_truncpt
This command initializes the primary database and sets the secondary truncation point to the end of the log.
The primary database must not be quiesced when you use pdb_init to initialize the primary database.
After you initialize the primary dabatase with pdb_init, you must not allow any DDL operations in the primary database before it is quiesced for the Mirror Replication Agent initialization.
When pdb_init is invoked with no option, Mirror Replication Agent does the following:
Verifies that:
The Mirror Replication Agent instance is in Admin state.
The primary database is not quiesced.
The RepAgent thread in the primary database is disabled.
Sets the secondary truncation point, only if it is not already set.
Marks all user tables in the primary database for replication in a warm standby application. This is equivalent to executing sp_reptostandby in the primary database.
When pdb_init is invoked with the move_truncpt keyword, Mirror Replication Agent does the same things as described in the previous item, except that it sets the secondary truncation point to the end of the log.
The pdb_init command returns an error if:
The primary database is quiesced.
The Mirror Replication Agent instance is in Replicating state.
To replicate stored procedures in the primary database, you must mark the procedures for replication using the sp_setrepproc, "function" procedure in the primary database for each procedure that you want to replicate.
If you mark a stored procedure using the sp_setreplicate or sp_setrepproc, "table" procedure, only the resulting data-changing operations on tables are replicated, not the procedure call itself.
Mirror Replication Agent 12.6 supports only request function delivery;
it does not support applied function delivery.
The pdb_init command is valid only when the Mirror Replication Agent is in Admin state.
