sysadmin purge_route_at

Removes all references to a primary Replication Server from a replicate Replication Server.

Syntax

sysadmin purge_route_at_replicate, replication_server

Parameters

replication_server – The name of the primary Replication Server to be purged from the replicate’s RSSD.

Examples

Example 1 – Purges the primary Replication Server, TOKYO_RS, from the replicate’s RSSD:
```
sysadmin purge_route_at_replicate, TOKYO_RS
```

Usage

Use sysadmin purge_route_at_replicate to remove all subscriptions and route information originating from a specified primary Replication Server after the route is dropped from it. This is useful after drop route with nowait is executed at the primary Replication Server.
If there is a route from the current Replication Server to the specified primary Replication Server, you must drop the route before executing this command.
If a subscription was materializing when drop route with nowait was executed at the primary Replication Server, a materialization queue may be left at the replicate Replication Server. Use sysadmin drop_queue to remove this queue.

Warning! Use sysadmin purge_route_at_replicate only if the drop route with nowait command was executed at the primary Replication Server or if the primary Replication Server is lost and will not be recovered.

Permissions

sysadmin purge_route_at_replicate requires “sa” permission.