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