Returns the current state of the Replication Agent instance and a brief description of the last action taken.
ra_status
ra_status
This command returns the status of the Replication Agent instance, as shown below:
State Action
------ ----------------------------
ADMIN Waiting for operator command
(1 row affected)
The ra_status command returns the current state and a brief description of the last action taken. If the first word in the action description is “Transitioning,” the Replication Agent instance is in transition between states. Some Replication Agent commands are not valid when the Replication Agent instance is in state transition.
Replication Agent states are:
Admin – in this state, the Replication Agent instance is running, but no connections are up. You can change any configuration parameter when the Replication Agent instance is in the Admin state.
Replicating – in this state, the Replication Agent Log Reader component is scanning the transaction log for operations to replicate from the primary database and the Log Transfer Interface component is sending LTL to the primary Replication Server.
For more information about Replication Agent states, see “Replication Agent states” in this book.
The ra_status command is valid when the Replication Agent instance is in either Admin or Replicating state.
quiesce, ra_statistics, resume, shutdown, suspend
