Truncates older versions of primary database users in the system data repository in the RASD.
ra_truncateusers locator
The log locator value (LTM Locator) that identifies the cutoff point for truncating older versions of database users from the system data repository.
When ra_truncateusers is invoked, it truncates all non-current versions of all primary database users in the system data repository older than the version identified by the locator value.
If the current (most recent) version of a user is older than the version identified by the locator value, it is not truncated.
Most common data definition language (DDL) commands and stored procedures executed in the primary database (such as sp_modifylogin) are recorded in the transaction log, and replicated to the standby database. When it processes those DDL transactions for replication, Mirror Replication Agent updates its RASD automatically, creating a new version of the affected primary database user(s).
Use ra_truncateusers as part of a periodic maintenance procedure to prevent the RASD from growing indefinitely. See “Maintaining the Replication Agent System Database” for more information.
You should back up the RASD using rasd_backup before you truncate it. See “Backing up the RASD” for more information.
The ra_truncateusers command is valid when the Mirror Replication Agent instance is in either Admin or Replicating state.
