rs_routeversions

Stores version information about the Replication Servers on each end of a route.

Column

Datatype

Description

dest_rsid

int

ID of the destination Replication Server

source_rsid

int

ID of the source Replication Server where this route is defined

dest_rssd_id

int

ID of the RSSD of the destination Replication Server

route_version

int

The minimum site version of the destination and source Replication Server

min_path_version

int

Reserved for future use

marker_serial_no

int

For internal use

status

int

Route status:

  • 0x00 – Valid

  • 0x01 – Route upgrade/recovery in progress, or route upgrade/recovery needed.

  • 0x02 – Route upgrade/recovery complete. This is a temporary status used by Replication Manager.

proposed_version

int

New route value in transition

Indexes

Unique clustered index on (dest_rsid, source_rsid)