Hi,
I set up the Transactional Replication on a database that is between two physical servers. Server A (SQL Server 2005) is the distributer and a Publisher. Server B (SQL Server 2000) is the Subscriber. I only set up the articles in "Tables" which I understand the "View" is not capable in SQL Server 2000
When I checked the Publication at the Replication Monitor, it indicates "Not Running" in the Status. The Performance is Excellent and Latency is 0. So, I checked the Warnings and Agents, it indicates the Snapshot Agent is Completed and the Log Reader Agent is Running. Obviously, I tried to test the server by updating a row in a table, and there is replication at all. I really have no clue where can I find the possibile error(s).
Can anyone guide me to fix this error?
Thank you.
I set up the Transactional Replication on a database that is between two physical servers. Server A (SQL Server 2005) is the distributer and a Publisher. Server B (SQL Server 2000) is the Subscriber. I only set up the articles in "Tables" which I understand the "View" is not capable in SQL Server 2000
When I checked the Publication at the Replication Monitor, it indicates "Not Running" in the Status. The Performance is Excellent and Latency is 0. So, I checked the Warnings and Agents, it indicates the Snapshot Agent is Completed and the Log Reader Agent is Running. Obviously, I tried to test the server by updating a row in a table, and there is replication at all. I really have no clue where can I find the possibile error(s).
Can anyone guide me to fix this error?
Thank you.