here is a situation I am facing and unable to find answer thus far:
I have created a trans replication (SQL Server 2005) from server A to B with just 1 article ( table with over 4 million rows). Publisher is going to just one subscriber (also 2005). After creating Publication and subscription the status is
Snapshot Agent generated and created a snapshot folder with data in Repldata.
Log Reader agent is running
Distributor is showing synchronization in progress and following message:
The concurrent snapshot for publication 'apiTransLog To 100.60' is not available because
it has not been fully generated or the Log Reader Agent is not running to activate it.
If generation of the concurrent snapshot was interrupted, the Snapshot Agent fo
This snapshot is not getting applied to the subscriber DB. What is wrong and what is the solution? I tried removing and recreating same replication twice but getting same results.
Please help.
Thanks.
HK