Show TOC

sysadmin purge_route_at_replicateLocate this document in the navigation structure

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.

Caution

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.