When you unmark a stored procedure, Mirror Replication Agent removes the transaction log objects that were created when the stored procedure was marked.
DDL replication must be disabled during the unmarking
of stored procedures. See “Disabling replication for DDL”.
To unmark a stored procedure
Log in to the Mirror Replication Agent instance with the administrator login.
Use the pdb_setrepproc command to confirm that the stored procedure is marked in the primary database:
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure that you want to unmark.
If the pdb_setrepproc command returns information that the specified stored procedure is marked, continue this procedure to unmark the stored procedure.
If the pdb_setrepproc command does not return information that the specified stored procedure is marked, you do not need to continue this procedure.
Use the pdb_setrepproc command to disable replication of the stored procedure:
pdb_setrepproc pdb_proc, disable
where pdb_proc is the name of the stored procedure that you want to unmark.
Use the pdb_setrepproc command to remove the replication marking from the stored procedure:
pdb_setrepproc pdb_proc, unmark
where pdb_proc is the name of the stored procedure that you want to unmark.
If you need to force the unmark, you can use the following command:
pdb_setrepproc pdb_proc, unmark, force
Use the pdb_setrepproc command to confirm that the stored procedure is no longer marked for replication:
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure in the primary database that you unmarked.
You can unmark all marked stored procedures in the primary database by invoking the pdb_setrepproc command with the all keyword.
If you disabled DDL replication during stored procedure
unmarking, remember to re-enable DDL replication. See “Enabling replication for DDL”.
