Verify the replicating state of Replication Agent.
resume
go
State Action
----------- --------------------------
REPLICATING Ready to replicate data.
1> resume 2> go Msg 32000, Level 20, State 0: Server 'rao', Procedure 'resume', Line 1: Command <resume> failed - Desired state <REPLICATE> could not be achieved. Current state: <REPLICATION DOWN>
ra_status
go
State Action
----------------- -----------------------
REPLICATING Ready to replicate data.
1> resume 2> go Msg 32000, Level 20, State 0: Server 'rao', Procedure 'resume', Line 1: Command <resume> failed - Desired state <REPLICATE> could not be achieved. Current state: <REPLICATION DOWN>
isql -Usa -P -SSAMPLE_RS
admin who
go
The DSI connection for the primary database connection is usually down because you are not replicating data back to the primary database.
The Replication Agent connection, if established for the replicate database connection, is usually down, because you are not replicating data from the replicate database.
admin who
go
Spid Name State Info
---- ---------- ---------------
--------------------------------
13 DSI EXEC Awaiting Command 101(1)
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
9 DSI Awaiting Message 101
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
8 SQM Awaiting Message 101:0
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
8 SQM Awaiting Message 101:0
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
54 DSI EXEC Awaiting Command 102(1)
my_mssql_access_service.rdb
53 DSI Awaiting Message 102 my_mssql_access_service.rdb
17 SQM Awaiting Message 102:0 my_mssql_access_service.rdb DSI EXEC Suspended 103(1) NY.NYmss5
DSI Suspended 103 NY.NYmss5
24 DIST Awaiting Wakeup 103 NY.NYmss5
25 SQT Awaiting Wakeup 103:1 DIST NY.NYmss5
23 SQM Awaiting Message 103:1 NY.NYmss5
22 SQM Awaiting Message 103:0 NY.NYmss5
62 REP AGENT Awaiting Command NY.NYmss5