Resetting the Primary Microsoft SQL Server Database for Replication
In
a test environment, you may occasionally need to reset the replication environment.
Protect your new environment from old log information by using this command in the Replication Agent to archive all current redo
log data:
ra_locator move_truncpt
Reinitialize Replication Agent, which refreshes the Replication Agent repository rather than overwriting it:
ra_admin refresh
Note:
If you prefer to delete and replace all the information in the
Replication Agent repository, issue the ra_admin deinit,
force command followed by a normal ra_admin
init command (without the force option).
Reset the locator stored in Replication Server:
isql -USAMPLE_RS_RSSD_prim -PSAMPLE_RS_RSSD_prim_ps-SSAMPLE_RS_ERSSD -DSAMPLE_RS_ERSSD
rs_zeroltm NY, NYmss5
go
You
see:
Locator has been reset to zero.
(return status = 0)