We have a TESTDB and transaction replication was setup to the subscriber db is REPORTSDB. Replication was working fine.
We have restored production datbase into TESTDB recently and I have setup Transactionl replication to REPORTSDB.
But the replicaiton monotor gives the below error.
"The concurrent snapshot for publication 'TESTDB' 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 Snaps"
Infact the snapshot agent was completed. and Log reader agent was running But shows 'no replicated transactions are availble'
But still the above error appears.
The replicaiton for other databases on the same server are running fine.
Please suggest me what needs to done to resolve this issue.
Thanks in Advance.