Deleting a Replication Server

You can remove Enterprise Replication from a database server and then remove the database server from an Enterprise Replication domain.

About this task

Run the cdr delete server command two times to remove Enterprise Replication from a database server, and then remove the database server from an Enterprise Replication domain. The first time, run the command on the server you want to remove Enterprise Replication from. The second time, connect to a different server in the Enterprise Replication domain and run the command, specifying the server you ran the first command on.

To remove Enterprise Replication from an inactive database server, use the cdr delete server command with the --force option.

To restart Enterprise Replication on a disabled database server, define the server again with the cdr define server command and then synchronize data. Row history is deleted when a server has Enterprise Replication removed, so the history is not recoverable if Enterprise Replication is restarted.

Warning: Do not delete an Enterprise Replication server and then immediately recreate it with the same name. If you recreate the objects before the operation finishes propagating to the other Enterprise Replication database servers in the domain, failures might occur in the Enterprise Replication system at the time of the operation or later.
Important: If you are creating a replicate to replace the one you deleted, use the cdr check queue --qname=ctrlq command to make sure that the delete operation propagated to all the servers.

Examples

To remove Enterprise Replication from local database server reynolds, and then remove database server reynolds from the Enterprise Replication domain it shares with database server stimpson, run the following commands:
cdr delete server reynolds
cdr delete server --connect=stimpson reynolds

The first command removes Enterprise Replication from the local database server, reynolds. The second command connects to database server stimpson, which is another server in the Enterprise Replication domain, and then removes database server reynolds from the shared domain.