Resetting the Primary Microsoft SQL Server Database for Replication

Learn how to reset the primary Microsoft SQL Server database for replication.

In a test environment, you may occasionally need to reset the replication environment. Instead of deleting and recreating a new Replication Agent instance, use this task to facilitate resetting the environment.

Protect your new environment from old log information by using this command in the Replication Agent to archive all current redo log data:
```
pdb_xlog move_truncpt
```
To retain marking and log device information, reinitialize the Replication Agent using pdb_xlog init with the force option, which forces the Replication Agent repository to be refreshed instead of overwritten:
```
pdb_xlog init, force
```
Note: If you prefer to delete and replace all the information in the Replication Agent repository, issue the pdb_xlog remove, force command followed by a normal pdb_xlog 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)